Virtuemart - parameter search optimization


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.


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

en 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 freelance font une offre moyenne de $188 pour ce travail


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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(796 Commentaires)

quick pro help. ftp and escrow required.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(577 Commentaires)

Hi please check pmb for details

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(167 Commentaires)

Please check PMB

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(374 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(171 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 8 jours
(53 Commentaires)

Please let me help you, thanks!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(138 Commentaires)

Please see PMB

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(74 Commentaires)

hello,im ready

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(22 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(11 Commentaires)