Loading data faster?

  • Thread starter Thread starter Arsalan
  • Start date Start date
A

Arsalan

Well, the problem is when i run the application 1st time, it takes time fill
the dataset, whereas if i run the application second time, it fills dataset
faster.

How do I make it faster on the 1st time ?
 
This is probably due initialization of first physicall connection. You can't
do much there (you might initialize one during application loading - in
worker thread perhaps (just open a connection))
 
Just as with any operation, the server can't cache the connection or the
data until it's been told to open or load it beforehand. The trick is to
make the job so easy that the length of time you wait is insignificant. You
can also set the minimum size of the cache in ASP applications so the next
time a connection is requested, it's already there are ready to go.

--
William (Bill) Vaughn
President and Founder Beta V Corporation
Redmond, WA
(425) 556-9205
Microsoft MVP, Author, Mentor
Microsoft MVP
 
Back
Top