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

Reply via email to