Magento - 显示缺货产品时间执行

Question

I have a large mysql database, so when i'm trying to set Display Out of Stock Products options in NO, i get php time execution error. Does anybody know native mysql query or some another trick to change this options? Please help. It's a shared hosting so i can't increase execution time of script

Answer 1

You could paginate your list and use MySQL LIMIT <start>,<length> options.

Example:

SELECT * FROM table WHERE (1=1) LIMIT 0, 100;

The above will select the first 100 items. For the next page, increase the first value by 100, and so on until there are no more rows.