Dibatalkan

Site performance optimization due to bad sql quiries

The project is about an online shop, built in Joomla 2.5.4 and Virtuemart 2.0.6 with a template from Templatemonsters.com.

The database includes [url removed, login to view] products and 1350 categories, in 3 languages.

Issues:

First page opens in about 15 to 35 secs. Other pages in about 16 seconds.

There are some sql queries that seem to load the whole database sometimes and look like they are in a loop, causing very low performance, timeouts and server overloads.

Notice: Google has cached some pages that have expired. Although they crawl the server using the cached links that are no longer exist. While this happens, most times the program lands to a page that reads all the records, causing server overload as well.

Need:

Find and replace the sql queries to avoid useless loads. Improve better performance using page caching, page compression, css & js compression, site optimization. Get rid of bad crawler requests.

Kemahiran: MySQL, PHP, Virtuemart, Ujian Laman Web

Lihat lebih lanjut: online shop joomla template, js products, online optimization, database caching, online website crawler, sql queries, sql database improve, performance testing, database performance , database optimization, compression online, online load testing, need performance testing, optimization database, joomla website optimization, online program testing, replace sql amp, improve performance, php google sql crawler, sql database crawler php, page load optimization, css online shop, better virtuemart css, online testing project joomla, project server 2013

Tentang Majikan:
( 1 ulasan ) LONDON, Greece

ID Projek: #4088651

6 pekerja bebas membida secara purata $389 untuk pekerjaan ini

gopalvora

ready to start Thanks

$600 USD dalam 8 hari
(138 Ulasan)
6.7
Ajcm623

hello i have gone through your requirement let me know if u are interested to discuss further thank u

$300 USD dalam 7 hari
(43 Ulasan)
5.8
kirilpanchev

Dear sir, I have over 10 years of experience in Web Development and Linux Administration including PHP, Smarty, MySQL, jQuery, etc. Expert in optimization. Also I am Zend Certified PHP Developer (ZCE). I can help you o Lagi

$300 USD dalam 3 hari
(28 Ulasan)
4.4
voja15

Hello, I have more than 5 years of experience in web design and development, so I can complete the job with quality. Also, I have experience in fixing speed problems in Joomla.

$385 USD dalam 7 hari
(15 Ulasan)
4.4
technofreakz

I am a Linux Consultant..

$250 USD dalam 2 hari
(18 Ulasan)
4.1
webdevit

php/mysql team

$500 USD dalam 5 hari
(6 Ulasan)
2.6