i imported around 1000 products in virtuemart web shob. I made one product type. I made 5 parameters for that product type. In SQL table jos_product_type_1 I removed "primary key" from product_id because one product can have different parameter value. I imported around 20000 rows in jos_product_type_1 sql table (thera are paremeter values of products)
Now, when i want to search by parameters it doesn't work good because there are so many queries. (i tested and it works good if there are less then 3000 rows, if i import more then 3000 rows it works realy slowly - in case of 20000 rows i get internal server error and searchin doesn't work ).
I would like to make optimization of search module by parameters, so that searching would be quick. I attached two excel files. One if file of products, second one is table of parameters.
10 freelancers are bidding on average $188 for this job
We are working in web development since last 4 years. Our first aim is reliable to submit quality project on time; Some of the Projects done by us:- [url removed, login to view]://[url removed, login to view] (Zend) [url removed, login to view]://[url removed, login to view] Plus