A view is being used to link data between 6 tables where the user can search at least 10 fields bringing back about 40 columns.
________________________________ From: MC Tay [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2008 4:12 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: cancel a query 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 [EMAIL PROTECTED] www.ogdengroup.com <http://www.ogdengroup.com/> ________________________________________________________________________ TO UNSUBSCRIBE: Go to <http://www.witango.com/developer/maillist.taf> http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf