In Progress

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 change template, virtuemart joomla

About the Employer:
( 0 reviews ) Kyiv, Ukraine

Project ID: #15205587

Awarded to:

TorarAbu

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

$115 USD in 3 days
(1 Review)
1.0

28 freelancers are bidding on average $160 for this job

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
(67 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
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
(80 Reviews)
6.2
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
(81 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
(68 Reviews)
6.1
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)
5.5
$155 USD in 3 days
(13 Reviews)
5.2
$55 USD in 1 day
(36 Reviews)
5.1
$166 USD in 2 days
(5 Reviews)
3.9
$244 USD in 3 days
(3 Reviews)
3.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
(399 Reviews)
4.1
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
(58 Reviews)
2.9
$155 USD in 3 days
(2 Reviews)
2.5
technofizi

Hi, We have gone through requirement that you websites pages are consuming long time while loading content from database because of query which applied to fetch data from MySQL database. As we have expertise with Joo More

$99 USD in 3 days
(2 Reviews)
1.6
codeniafreelance

#### BEST AND AFFORDABLE JOOMLA, MYSQL EXPERT #### Hi Sir Greetings I read your requirements and also check your website, I understood that you have speed issue with few product pages. I have 7+ years of expe More

$100 USD in 3 days
(0 Reviews)
0.0
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
(7 Reviews)
0.0
creativesols3

Hi, i am a full stack mobile & web dev having similar technical skills & experience & have already worked on a similar project before so can do this Ref : [url removed, login to view] Great exp More

$155 USD in 3 days
(0 Reviews)
0.0
toshazed

I am Ring. I am about 16+ years experienced in GNU/Linux based system, server installation and customization, develop, deploy, security and support. I may help you in this regard.

$100 USD in 2 days
(3 Reviews)
0.0
$133 USD in 3 days
(0 Reviews)
0.0
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
(659 Reviews)
0.0