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
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.