If the index is setup properly, querying 1000 records out of 3.5
million records should be pretty fast.
We have a query retrieving 500-1000 records from 1.75 million records
in a three table joint, and it takes about 3 to 6 seconds.
MC
At 08:29 AM 3/28/2008, you wrote:
Hi,
I have a site where a user can submit a complex query to search a
3.5+ million record table. Once submitted, the query is set-up to
bring back only the first 1000 records. While waiting for the
results, the user hits the back button or closes the browser window,
how does Witango handle the cancelling of the query? Does the query
still continue until the results are ready to be transferred to
Witango? Is there a correct way to cancel the query and restore
resources to the server?
Ted Wolfley
Lead Internet and Database Programmer
The Ogden Group of Rochester
phone: (585) 321 1060 x23
fax: (585) 321 0043
<mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED]
www.ogdengroup.com
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf