Completed

DB MySQL Virtuemart Joomla 3.6

It is needed to ecnrease page speed of some pages that have slow page speed due to big amount of SELECT queries to MySQL.

Details:

I have a site Joomla 3.6 Virtuemart: intelli.com.ua.

Generely site works well, but

some Virtuemart pages have very slow page speed.

For example, loading speed is satisfactory of this page:

[url removed, login to view]

But pagese with products opens during 8 seconds +/- 5 seconds.

For example, pages:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

I have made strace of one page: [url removed, login to view]%D0%BA%D1%83%D0%BB%D0%BE%D0%BD-gps-%D1%82%D1%80%D0%B5%D0%BA%D0%B5%D1%80-3g-%D1%81-%D1%84%D0%BE%D1%82%D0%BE-%D0%BA%D0%B0%D0%BC%D0%B5%D1%80%D0%BE%D0%[url removed, login to view]

According to strace, slow page speed is caused by 1208 SELECTs to database.

You can check strace here: [url removed, login to view]

It is needed to encrease page speed and make it normal (1 seconds or less) if it is possible. Aslo, you can make your proposals according to page speed.

Some of queries runs more than 1 second:

# Time: 170915 17:30:56

# User@Host: u_intj3[u_intj3] @ localhost []

# Query_time: 2.428587 Lock_time: 0.000039 Rows_sent: 527018 Rows_examined: 527018

use intj3;

SET timestamp=1505485856;

SELECT `id`, `origurl`, `Itemid`, `sefurl` FROM `jos_sefurls` WHERE `sefurl` = 'ru/[url removed, login to view]' AND `origurl` != '';

# Time: 170915 17:30:58

# User@Host: u_intj3[u_intj3] @ localhost []

# Query_time: 2.536321 Lock_time: 0.000082 Rows_sent: 527018 Rows_examined: 527018

SET timestamp=1505485858;

SELECT `id`, `origurl`, `Itemid`, `sefurl` FROM `jos_sefurls` WHERE `sefurl` = 'ru/[url removed, login to view]' AND `origurl` != '';

# Time: 170915 17:30:59

# User@Host: u_intj3[u_intj3] @ localhost []

# Query_time: 2.479606 Lock_time: 0.000031 Rows_sent: 527019 Rows_examined: 527019

SET timestamp=1505485859;

SELECT `id`, `origurl`, `Itemid`, `sefurl` FROM `jos_sefurls` WHERE `sefurl` = 'ru/[url removed, login to view]' AND `origurl` != '';

# Time: 170915 17:31:00

# User@Host: u_intj3[u_intj3] @ localhost []

# Query_time: 2.015890 Lock_time: 0.000039 Rows_sent: 527020 Rows_examined: 527020

SET timestamp=1505485860;

SELECT `id`, `origurl`, `Itemid`, `sefurl` FROM `jos_sefurls` WHERE `sefurl` = 'ru/[url removed, login to view]' AN

_______________________________________________

Ребята, нужна помощь.

Нужно протестировать сайт и понять, почему долго загружается карточки товаров.

Страница, которая загружается с удовлетворительной скоростью: [url removed, login to view]

Карточки товаров, которые загружаются долго:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

И все остальные.

Если сможете понять причину, ожидаю и решение проблемы, по возможности.

Хостинг предоставил следующую информацию:

Произвели strace одного обращения к сайту по ссылке:

[url removed, login to view]%D0%BA%D1%83%D0%BB%D0%BE%D0%BD-gps-%D1%82%D1%80%D0%B5%D0%BA%D0%B5%D1%80-3g-%D1%81-%D1%84%D0%BE%D1%82%D0%BE-%D0%BA%D0%B0%D0%BC%D0%B5%D1%80%D0%BE%D0%[url removed, login to view]

Судя по strace долгое время ответа сервера связано с большим количеством SELECT запросов в базу данных.

При одном обращении к сайту происходит 1208 SELECT запросов в базу данных.

Вывод strace положили в текстовом формате в корень домашнего каталога домена [url removed, login to view] (/var/www/intelli/[url removed, login to view]).

Покажите этот файл разработчику сайта для оптимизаций кода сайта и оптимизации запросов при обращении к сайту.

PS. Файл с анализом: [url removed, login to view]

Skills: Joomla, MySQL, PHP, Virtuemart

See more: joomla 3.6 free, joomla site to joomla 3.6, web templates free joomla 3 e virtuemart, joomla 3.4 mobile site aktivieren, i need help with joomla 3 update, mysql performance joomla virtuemart performance, setup ssl virtuemart joomla site, virtuemart joomla mysql, clone virtuemart joomla site, move virtuemart joomla site, integrate virtuemart joomla site, mysql servers virtuemart joomla, picture thumbnail flypage virtuemart joomla site, virtuemart joomla upgrade, free templates virtuemart joomla, virtuemart joomla templates, virtuemart joomla template coupon code, change encoding mysql database joomla, mysql myadmin joomla, category virtuemart joomla menu, virtuemart joomla change template, virtuemart joomla

About the Employer:
( 1 review ) Kyiv, Ukraine

Project ID: #15205587

Awarded to:

TorarAbu

Привет! В логах ничего полезного нет, но да, SELECT'ов очень много. Позволь посмотреть тестовые запросы в базу, так будет легче быстрее найти проблему. В логах точно есть полезная информация, но её нужно долго иска More

$115 USD in 3 days
(2 Reviews)
2.3

27 freelancers are bidding on average $160 for this job

sanjay2004

We will optimize CSS, HTML, Javascript and images on your website according to GT Metrix analysis so that your website loads properly with optimum loading time. please send me your website link ...

$206 USD in 0 days
(664 Reviews)
9.7
gopalvora

Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joo More

$180 USD in 7 days
(443 Reviews)
8.2
Shopify

Hello, Greetings from Shopify. I am glad to inform you that we have 46+ Technical resources team having said that they have 5+ years of experience in development and designing . 32 of them are working on PHP and 1 More

$257 USD in 10 days
(24 Reviews)
6.9
pgpatel

Joomla/Virtuemart Speed Optimization I am doing website speed optimization from last 3+ years. I have worked many websites and know how to optimize website with servers like Apache HTTP Server, Internet Information More

$166 USD in 2 days
(81 Reviews)
6.5
sat12

I can try to make it fast. I am Joomla,PHP prog rammer having 5 years of experience. I am very good in wordpress,php,mysql,joomla. I have done highest projects here in Joomla.

$155 USD in 3 days
(402 Reviews)
6.9
hawkscodeaus

Hi, I can start work on your project immediately once you confirm me and i am also open for further discussion if you want. I have 7+ years in web designing & development with good experience in following skills More

$200 USD in 3 days
(79 Reviews)
6.9
miracitech37

hello we have expertise in a website . we have developed we have 100 of website ping me on chat I will be explained more about my experience I do not have much space to write I have 10 years of experience More

$155 USD in 3 days
(17 Reviews)
6.0
ShiaFirst

Hi, its pretty simple for me but I have few questions to ask, knock me for further discussion, PLEASE DON'T AWARD PROJECT BEFORE DISCUSSION. Thank You!

$200 USD in 3 days
(82 Reviews)
6.2
karunakartiwari

Hi, Greeting for the day, Hope you are doing well Please initiate chat to discuss your requirement in details. Thanks Karun

$200 USD in 1 day
(72 Reviews)
6.1
$155 USD in 3 days
(15 Reviews)
5.3
ykarora26

I am an experienced full stack web master, working with Joomla, shopify, big commerce, prestashop, volusion and Word press for over 9 years . I have knowledge of HTML5, CSS3, jQuery, Angularjs2, PHP, Bootstrap, Uikit, More

$123 USD in 3 days
(69 Reviews)
5.5
ieota

Dear Client, Thanks for your job post over Freelancer. I review your shared requirement and applying for this job just becuase of my previous vast amount of experience and now I would like to discuss your requiremen More

$155 USD in 3 days
(18 Reviews)
5.2
$55 USD in 1 day
(38 Reviews)
5.1
shahalam7303

Hello, I have properly gone through your job description and understood your requirements. I'm very eager to work on this project. I'm very skilled and expert on Web development, Graphics design, Content writing More

$155 USD in 3 days
(6 Reviews)
4.9
$166 USD in 2 days
(5 Reviews)
3.9
amit0423

Hi, As per your requirement, i would like to tell you that i am a PHP Web developer, experienced in PHP, html & MySQL web programming, designing, XHTML/HTML/CSS coding and Javascript/AJAX programming. Spare a mo More

$155 USD in 3 days
(8 Reviews)
4.1
BeautiCG

Hi, I am an experienced programmer and I'm sure I can complete your project asap. Please contact me and tell about your project details. I promise a high quality and punctual work. Thanks. ProjectName:DB MySQL Virtuem More

$155 USD in 1 day
(14 Reviews)
4.5
$244 USD in 3 days
(3 Reviews)
3.5
$155 USD in 3 days
(4 Reviews)
3.6
beckondelveinfo

Hello There, Greetings ! I have studied your details & will be glad to assist you. MY EXPERIENCE -------- I'm a full stack Sr. WEB DEVELOPER having 6+ years of experience in Wordpress Development & worked More

$277 USD in 3 days
(5 Reviews)
3.3