Hello Everyone,



I am having a long delay in one of my asp pages when it calls the 

database. It takes a few seconds for the page to load on my local machine. 

It grabs records from a database that has a total of about 6 million 

records. Is it taking for ever to load because the database is too big? or 

could something be wrong with my code on that page? This is the only page 

that takes forever but the only one that calls this database.



FYI, the project is on a local machine with only 1 celeron processor and 

256mb of ram. It will normally reside on a Dell PowerEdge server with 2 

Pentium 3, 1Ghz. processors and about 1,000mb of ram. Should that take 

care of it? Please help. Thanks!



Regards,

Elmer M.

It could be anything from your description:

a) database query is taking too long because

    - database server is under powered

    - database not designed optimally (indexes etc)

    - database not tuned (eg denormlised to minimise joins)

    - database query not optimal

b) page processing is taking a long time because

    - of poorly implemented code

    - long marshalling times as data is marshalled from the database server

c) page rendering is taking a long time because

    - HTML contains large tables which wont render until the closing

</table> tag is reached

    - large amounts of data need to be marshalled to the client

etc, etc, etc



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: <info@e...>

Subject: [asp_databases] Huge SQL Database & ASP





: I am having a long delay in one of my asp pages when it calls the

: database. It takes a few seconds for the page to load on my local machine.

: It grabs records from a database that has a total of about 6 million

: records. Is it taking for ever to load because the database is too big? or

: could something be wrong with my code on that page? This is the only page

: that takes forever but the only one that calls this database.

:

: FYI, the project is on a local machine with only 1 celeron processor and

: 256mb of ram. It will normally reside on a Dell PowerEdge server with 2

: Pentium 3, 1Ghz. processors and about 1,000mb of ram. Should that take

: care of it? Please help. Thanks!



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~