Re: Query takes long time to execute

2003-06-13 Thread Ryan Fox
On Friday 13 June 2003 09:29 pm, Mark Stringham wrote: > I'm querying a table of approximately 42 records based on 3 criteria. The > results are then displayed in a pop-up window. When the query is executed > the first time - the window opens and stalls for about 3 seconds before > the results ar

Query takes long time to execute

2003-06-13 Thread Mark Stringham
I'm querying a table of approximately 42 records based on 3 criteria. The results are then displayed in a pop-up window. When the query is executed the first time - the window opens and stalls for about 3 seconds before the results are displayed. An example query would be : select * from $tabl