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!