ADO & Initial Table Query

[Tony Ford]

How can I speed up the initial SQL query sent to a table?

My problem lies in that my first query to a table takes 30 to 40 seconds
to come back.
However, subsequent queries only take a second or two. How can I speed up
this first
query or how can I 'hide' the time? I've tried executing the query at startup
and was looking
at running it in the background but haven't found any reasonable solution.

Any ideas?

[Perry Forman]

What is your backend. There's a possibility that whatever your doing is
getting cached. So there is always the initial load time.

PF

"Tony Ford" <Tony.Ford@abi.org.uk> wrote in message
news:38ec6581$1@news.devx.com...
>
> How can I speed up the initial SQL query sent to a table?
>
> My problem lies in that my first query to a table takes 30 to 40 seconds
> to come back.
> However, subsequent queries only take a second or two. How can I speed up
> this first
> query or how can I 'hide' the time? I've tried executing the query at
startup
> and was looking
> at running it in the background but haven't found any reasonable solution.
>
> Any ideas?
>
>
>