Virtuemart - parameter search optimization
$30-250 USD
Paid on delivery
Hey,
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.
Thanks
Project ID: #2333041
About the project
10 freelancers are bidding on average $188 for this job
Hello, After having look at your requirement, I would like to offer you our quality services which will be your ultimate goal and requirement to have. With the market presence of 5+ years, we have worked on 1500+ More