I have script in php+mysql which simply prints out the database. the problem is it's pretty huge so i need to echo it in cycle by 1000 items. i used to run it on apache where it simply echoed 1000 lines, then waited a bit to process the mysql query, then echoed another 1000 and so on until it printed everything out.
Now i switched to nginx and the server now waits for the whole page to load, which means to print out 100 000 items from the database, which can take A LOT of time and it usually just times out. is there some way to fix this and make it work like on apache?
thanks