Product Search Problems
We operate a large affiliate site and recently we have added around 100,000 products and the product search function of the site has gotten really slow. I need to add at least another 200,000 products to the database, but the system is already too slow. We are running SQL 2000 Enterprise. Any help would be great.
Chad Jaquays
Traffic Strategies.com
[email protected]
813-673-8350
nitin posted this at 06:22 — 7th August 2003.
They have: 4 posts
Joined: Aug 2003
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
Webmaster tools, tutorials and tips.
Get a FREE ebook on Building Dynamic Web Sites
technobuff.net
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.