Thread: Performance Question

Hi,
We have a database with over 100,000 items on MLv 8.0. We are having major performance issues with search delay. The site is running extremely slow and if you do a search, well, it takes over 30 seconds to come up with a result. Many times it would just time out. The site is running really slow over all as well. An user would click on a category and it would take forever to come up. Our programmer explains that the ASPDSF codes build in a lot of extra codes, so that when a search is conducted it has to go through layers of queries. Sorry for the layman term, but I'm no programmer as you can tell.
We've tried to fix the problem by increasing the memory to 8GB, but does anyone here experience the same issue and do you have a software fix for it?

Thanks so much!

Are you hosting your web and DB on the same server/location? Your site's performance is really dependent on the speed of your SQL Server, because it does most of the heavy lifting. All of the time-consuming product searching and filtering is done via stored procedures on SQL Server, with just a small result-set being passed back for display to the customer. If you optimize the performance of SQL Server by providing it with a fast box with lots of RAM, that will directly translate to better AspDotNetStorefront performance.

You'll also want to consider full text indexing, upgrading from SQL Express (if you're using SQL Express...Express is limited to 1 GB of ram), taking a look at our large site performance tuning guide, and using SQL Profiler to see if you can narrow down where things are bottlenecking.