o now that i can do that but i opening this query in access and not in witango we are moving from access to sql but there is still a access application that needs to work on sql
so i need to now if there someway to make the query faster in sql ----- Original Message ----- From: "Dan Stein" <[EMAIL PROTECTED]> To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 1:03 PM Subject: Re: Witango-Talk: sql access question > If I understand you correctly somehow your doing the query limiting it to x > records then doing it again to get the rest? > > Anyway if you use the search builder as a starter and tell it to limit to 25 > then show multiple pages if total is exceeded it will find the whole record > set and just show 25 of the array then when you click on next it will show > the next 25. > > It does a nice job or coding all the buttons etc. > > If you don't want to do that then drag over the search action choose the > same limits for your results and then code the previous and next yourself. > > Basically your at rows start and stop of the array is 1-25 then 26-51 etc. > > Once query then just displaying the results from the array stored in memory. > Will be very fast. > > Dan > > on 6/27/02 5:12 AM, robert at [EMAIL PROTECTED] wrote: > > > hi if have a question about sql a have a query that takes in access about 4 > > to 5 seconds > > and in sql it takes 2 to 3 second so make the the query > > > > but the problem in that when i want to use the sql query in access it show > > 10 record and when i scroll down > > it need to get the next 10 record from the sql server but then 2 second to > > get the next record > > > > so when i go tru the hole record set it takes me 30 second in sql > > > > > > but in access makes the hole recordset availible in 1 time so it only takes > > me 4 to5 second > > is there a way to make the sql query faster > > > > greeting robert > > > > > > ________________________________________________________________________ > > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > > with unsubscribe witango-talk in the message body > > > > -- > Dan Stein > Digital Software Solutions > 799 Evergreen Circle > Telford PA 18969 > Land: 215-799-0192 > Mobile: 610-256-2843 > FMP, WiTango, EDI,SQL 2000 > [EMAIL PROTECTED] > www.dss-db.com > > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body