On Thu, 4 Nov 2004 18:20:18 -0000, Matt Clark <[EMAIL PROTECTED]> wrote:
Correct the 75% of all hits are on a script that can take anywhere from a few seconds to a half an hour to complete. The script essentially auto-flushes to the browser so they get new information as it arrives creating the illusion of on demand generation.
Er, do you mean that :
1- You have a query that runs for half an hour and you spoon feed the results to the client ?
(argh)
2- Your script looks for new data every few seconds, sends a packet, then sleeps, and loops ?
If it's 2 I have a readymade solution for you, just ask.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
