Hi,
I have a heavily modified creloaded installation and when a person does a search, it takes a very long time to complete, around 1-2 minutes. I suspect that product specials is the cause for this problem, since right now I have around 3000 products that are discounted using that feature. What I need is for an experienced oscommerce/creloaded programmer to fix the problem and make the search faster. Provider must be able to guarantee results and the search time must be significantly reduced.
i think you should change the sql query to be more specific such as product that date less than or equals date now or yesterday Or product which the name begin with Nest to find Nestle Try to be more specific