Increasing the speed of database indexing

message from cubanallstar on 19 Jul 2004
I have just finished building a dynamic driven site that is up on a company
intranet. The system is linked to an SQL Server database and displays lots of
information on clients and products under development. The trouble i'm finding
though is that it takes quite a long time for the pages to load before they're
cached. At times it's painfully slow!

Why is this occurring? Is it a problem with my indexing or source code? Is
there a way of speeding things up?

Regards,

Cubanallstar.
 

Archived message: Increasing the speed of database indexing (Macromedia Dreamweaver)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.