Fermé

Virtuemart - parameter search optimization

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

Compétences : Joomla, MySQL, PHP, Architecture Logicielle, Virtuemart

Voir plus : web search optimization, thera, table optimization, web server optimization, php internal error, php internal server error, virtuemart table joomla, internal server error php, internal server error virtuemart, php server optimization, module search, excel table virtuemart, table joomla search, search module joomla virtuemart, excel 3000 rows, virtuemart product key, web search parameters, primary key, table search joomla, sql import files, sql queries virtuemart, virtuemart sql php, virtuemart 500 internal server error, sql server virtuemart, excel import joomla

Concernant l'employeur :
( 3 commentaires ) 1262 Dol pri Ljubljani, Slovenia

N° du projet : #2333041

10 freelancers are bidding on average $188 for this job

kabirchy

Hi, let me help you get this done. I will speed up search process. Thanks

150 $ USD en 2 jours
(796 Commentaires)
8.3
toinnisfree

quick pro help. ftp and escrow required.

220 $ USD en 3 jours
(577 Commentaires)
8.0
AtlanticSoft

Hi please check pmb for details

350 $ USD en 4 jours
(167 Commentaires)
7.8
rabbul

Please check PMB

150 $ USD en 2 jours
(374 Commentaires)
7.8
itcslive

Dear sir, we are a web design, web development expert company. We are offering an efficient,professional ,friendly service. Can you check our skills in Private message box and discuss with us about your project? Thanks Plus

150 $ USD en 3 jours
(171 Commentaires)
7.4
dinotech

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

250 $ USD en 8 jours
(53 Commentaires)
6.6
terrycoder

Please let me help you, thanks!

135 $ USD en 2 jours
(138 Commentaires)
6.6
sat12

Please see PMB

100 $ USD en 2 jours
(74 Commentaires)
5.5
westcowboy

hello,im ready

120 $ USD en 1 jour
(22 Commentaires)
5.1
sigmasolve

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+ Plus

250 $ USD en 7 jours
(11 Commentaires)
4.3