Page Load Very SLOW---Please Help!

[MnM]

We have a huge table in our database (about 200,000 records) and I have to get information from this table in my ASP for all of our stores (about 27). Right now it takes about 1 minute 50 seconds to run, I've tried using the GetRows and even a few Stored Procedures and it didn't help the load time at all. I was wondering it anyone had any other ideas. When I read about the GetRows and SP I was so excited I figured they would help a little.

 

[MatDavies]

You could try writing a COM module to handle getting the data, and return that to the page. It may speed it up some.

Also it depends on how you are outputting the data, are you concatenating a string and outputting that or sending data straight to the response object.
The concatenation in vb script is very slow.

Mat

 

[MnM]

To show the data I'm using response.write

I'll check into writing a COM module I know nothing about them. Thanks!

 

[MatDavies]

Just had a thought, you mention that your stores need this.
How do they connect to the server, I assume through a dial up. you coul dpage the data so that you do not need to send them the whole data at once, let them click next page or something like that. of course this depends on what sort of data you have, and what sort of comparisons they need to make.

Mat

 

[MnM]

What it is our Genreal Office Intranet, thus it's on our network, it is one report with all stores on this one report. It lists the store then the information, the next store and so fourth.

 

[Ovatvvon]

why don't you page per store, or seperate it by some kind of way? I think MatDavies is right, you should try a pageing technique if these other ways aren't working...and the time you have stated is way too long...a minute is way to long....20 seconds is borderline too long. However you said this is an intranet...but obviously speed is still important. That's what I suggest, as has MatDavies. -Ovatvvon :-Q