Changes between Version 10 and Version 11 of OtherTopics

Timestamp:

02/27/26 06:29:59 (3 weeks ago)

Author:

221181

Comment:

--

OtherTopics

@@ -141 +141 @@
 
 Обем на тест податоци:
-250.000+ редови (Табела за продажби),
-50.000+ редови (Табела за нарачки),
-10.000+ производи (Табела за производи)
+500.000+ редови (Табела за нарачки),
+100.000+ производи (Табела за производи)
 
 {{{
@@ -149 +148 @@
 TRUNCATE purchase_order, product RESTART IDENTITY CASCADE;
 
--- 10.000 производи
+-- 100.000 производи
 INSERT INTO product (name, description, sku, unit_price, category_id, supplier_id)
-SELECT 'Product ' || i, 'Desc', 'SKU-' || i, (random() * 100)::numeric(12,2), 1, 1 FROM generate_series(1, 10000) AS i;
-
--- 50.000 нарачки
+SELECT 'Product ' || i, 'Desc', 'SKU-' || i, (random() * 100)::numeric(12,2), 1, 1 FROM generate_series(1, 100000) AS i;
+
+-- 500.000 нарачки
 INSERT INTO purchase_order (order_date, expected_delivery_date, status, supplier_id, warehouse_id)
-SELECT CURRENT_DATE, CURRENT_DATE + i, CASE WHEN i % 2 = 0 THEN 'Pending' ELSE 'Received' END, 1, 1 FROM generate_series(1, 50000) AS i;
+SELECT CURRENT_DATE, CURRENT_DATE + i, CASE WHEN i % 2 = 0 THEN 'Pending' ELSE 'Received' END, 1, 1 FROM generate_series(1, 500000) AS i;
 }}}
 
@@ -164 +163 @@
 {{{
 SELECT * FROM purchase_order WHERE status = 'Pending';
+EXPLAIN ANALYZE SELECT * FROM purchase_order WHERE status = 'Pending';
 }}}
 
@@ -201 +201 @@
 {{{
 SELECT * FROM product WHERE name LIKE 'Laptop%';
+EXPLAIN ANALYZE SELECT * FROM product WHERE name LIKE 'Laptop%';
 }}}