Optimize MySql database - Virtuemart - Joomla 2.5

Virtuemart store has 10's of thousands of products and is running rather slow.

A search module using customfields is very very slow,

the evidence indicates some like 1400 queries are launch when a search is performed and this will not work.

Several methods of sql optimizations could be tried , im interested in any and all proposals. Please indicate what

experience you have with these kind of problems.

Thank you

Habilidades: Joomla, MySQL, SQL, Virtuemart

Veja mais: optimize mysql, optimize sql queries, sql optimize, joomla optimize mysql database, slow queries, joomla mysql search module, virtuemart slow optimize, mysql slow queries, mysql slow, search module joomla virtuemart, database problems, optimizations, mysql queries using, mysql virtuemart products, sql queries virtuemart, optimize sql joomla, optimize joomla database, joomla mysql search, database module joomla, joomla virtuemart store, mysql work slow, sql slow joomla, joomla database queries, search module virtuemart joomla, virtuemart mysql database

Acerca do Empregador:
( 8 comentários ) twin lakes, United States

ID do Projeto: #5106452

Concedido a:


Hello I can optimize all your sql queries and decrease your over load time. Are you on a shared or dedicated server?

$250 USD em 5 dias
(229 Comentários)

17 freelancers are bidding on average $222 for this job


Hello, We are a web development company at HaNoi, VietNam. We can work on a wide range of projects and many fields at the same time and we always look for building a long term relationship with clients. You can c Mais

$350 USD in 7 dias
(162 Comentários)

Hi I am confident to do this job. --------------------------------------------------------------------------------------------------------------------------------------------------- thanks

$263 USD in 3 dias
(394 Comentários)

Hi i have more then 6 year experience in Joomla , Virtumart.. And i have done many project in Joomla , virtumart and Php related .. so i am ready to start this new work Thanks

$175 USD in 5 dias
(154 Comentários)

A proposal has not yet been provided

$263 USD in 3 dias
(104 Comentários)

Dear Sir, We have gone through your requirements. We have professional level expertise driven by experience, professional wisdom and enthusiasm; we offer you cost effectiveness, functionality, the uniqueness of design Mais

$257 USD in 5 dias
(35 Comentários)

Hello Sir, We have gone through the details you have provided and would be pleased to work on this with you to deliver the results that you have expected and We are sure you will not be disappointed if you give us Mais

$164 USD in 5 dias
(26 Comentários)

Need to discuss this in detail,please tell me how we can start the discussion on this requirement. for more detail check in Private Message. We have a team of professionals,they have more than 11 year of experience,so Mais

$245 USD in 12 dias
(9 Comentários)

Hi, Let me do this project for you. Thanks.

$222 USD in 3 dias
(59 Comentários)

Hello, I'm ready when you are, You can check my feedbacks for mysql-server optimisation and server security. Could please send me the config of your server so I can get the (code) optimizer ready to run. Regards, Mais

$210 USD em 1 dia
(11 Comentários)

Greetings, I am glad to express my keen interest in the job which you have posted. I am ready to start your work ASAP! I possess good expertise of working on Joomla, PHP, MySQL, HTML, CSS, Virtue-mart, eCommerce, Mais

$216 USD in 3 dias
(9 Comentários)

Hello Sir, We have checked your job detail and as per that we are able to do your job and we have very good experience in Word Press, Joomla, Joomla component, Modules, PHP, HTML,Magento etc . As well knowledge on Mais

$206 USD in 6 dias
(10 Comentários)

HI I am Mainly DB developer with PHP programming experience I propose to help you in tuning the DB and queries It is not convincing to say 1400 queries for search since vituemart may not be having more than 1 Mais

$125 USD in 3 dias
(2 Comentários)

Dear we have a team of 12 people that can handle your [url removed, login to view] have done many projects..we will follow according to your [url removed, login to view] only after the [url removed, login to view] will give you best result with limited [url removed, login to view] Mais

$257 USD in 8 dias
(2 Comentários)

Hi, I have a lot experience with MySql. Did you try to index right field in table ? Are you sure that you use right data type in tables? Did you try to use MyIsam? Do you have repeated data in tables? Maybe you can nor Mais

$155 USD in 5 dias
(1 Comentário)

Dear client, We have understood your requirements and would deliver the same with 'top notch' quality. Our panel of experts are here at your disposal and will follow a roadmap to achieve the given task in hand. Al Mais

$263 USD in 7 dias
(1 Comentário)

Hi kumuchicago, We have 50+ skilled web development team. Please give few minutes for technical discussion of the project. Waiting for your reply & chance for further discussion. [url removed, login to view] Mais

$257 USD in 12 dias
(1 Comentário)

A proposal has not yet been provided

$155 USD in 3 dias
(0 Comentários)

A proposal has not yet been provided

$211 USD in 3 dias
(0 Comentários)

Hello, I have experience and can help you. But if you have a deducated server? Best wishes, Alexei

$155 USD in 3 dias
(0 Comentários)