Possible bug: Prestasho with many (20.000) products kills database

[peterlyberth]

Hi there.

Our host contacted about a problem with our store killing the database.

 

13459146 | billigih | pro18.meebox.net:47087 | billigih_newdb | Query | 1543 | Locked | SELECT COUNT(*) AS `count` FROM `billigih_newdb`.`ps_stock_available` WHERE (CONVERT(`id_stock_avail |
| 13459306 | billigih_billig | pro18.meebox.net:47299 | billigih_newdb | Query | 1544 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459458 | billigih_billig | pro18.meebox.net:47487 | billigih_newdb | Query | 1504 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459524 | billigih_billig | pro18.meebox.net:47576 | billigih_newdb | Query | 1481 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459526 | billigih_billig | pro18.meebox.net:47578 | billigih_newdb | Query | 1481 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459543 | billigih_billig | pro18.meebox.net:47610 | billigih_newdb | Query | 1478 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459565 | billigih_billig | pro18.meebox.net:47644 | billigih_newdb | Query | 1471 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459606 | billigih_billig | pro18.meebox.net:47706 | billigih_newdb | Query | 1457 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459639 | billigih_billig | pro18.meebox.net:47750 | billigih_newdb | Query | 1450 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459681 | billigih_billig | pro18.meebox.net:47797 | billigih_newdb | Query | 1440 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459684 | billigih_billig | pro18.meebox.net:47800 | billigih_newdb | Query | 1439 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459692 | billigih_billig | pro18.meebox.net:47811 | billigih_newdb | Query | 1436 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459707 | billigih_billig | pro18.meebox.net:47828 | billigih_newdb | Query | 1431 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459710 | billigih_billig | pro18.meebox.net:47833 | billigih_newdb | Query | 1430 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459738 | billigih_billig | pro18.meebox.net:47883 | billigih_newdb | Query | 1422 | Locked | SELECT SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 48254) AND (id_product_attribute |
| 13459759 | billigih_billig | pro18.meebox.net:47918 | billigih_newdb | Query | 1416 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459784 | billigih_billig | pro18.meebox.net:47954 | billigih_newdb | Query | 1410 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459832 | billigih_billig | pro18.meebox.net:48016 | billigih_newdb | Query | 1396 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459853 | billigih_billig | pro18.meebox.net:48041 | billigih_newdb | Query | 1390 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459862 | billigih_billig | pro18.meebox.net:48053 | billigih_newdb | Query | 1389 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13459897 | billigih_billig | pro18.meebox.net:48100 | billigih_newdb | Query | 1382 | Locked | SELECT SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 48254) AND (id_product_attribute |
| 13460002 | billigih_billig | pro18.meebox.net:48243 | billigih_newdb | Query | 1356 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13461628 | billigih_billig | pro18.meebox.net:50540 | billigih_newdb | Query | 1039 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13461922 | billigih_billig | pro18.meebox.net:51020 | billigih_newdb | Query | 983 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |
| 13462629 | billigih_billig | pro18.meebox.net:51960 | billigih_newdb | Query | 824 | Locked | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_a |

 

 

The sql statements are used in category.php, and as far as I can see, it has to make those queries to show the products.

 

Is this a bottleneck in the host or in prestashop itself?