Did you consider indexing your database?

nitin — Thu, 07 Aug 2003 06:22:38 +0000

Hi,

Not knowing enough about your data model, a simple question would be do you have appropriate indexes on the appropriate tables. What I would suggest is as follows
- If you know the queries you are firing, execute these from the database client's tool and see their response. This will tell you roughly how long it takes to execute the query itself.
- Analyze the query using the database-specific query explanation statements (such as "explain", etc.) I haven't used SQL 2000, but in general, all databases have some sort of mechanism to analyze the queries. Perhaps looking up the command reference would help.

Good luck!
- Nitin