Đã hoàn thành

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]

Kĩ năng: Joomla, MySQL, PHP, Virtuemart

Xem nhiều hơn: joomla 3.6 free, joomla site to joomla 3.6, web templates free joomla 3 e virtuemart, php, mysql, html, joomla, sql, javascript, linux, amazon web services, ubuntu, linux platform, 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

Về Bên Thuê:
( 1 Nhận xét ) Kyiv, Ukraine

ID dự án: #15205587

Được trao cho:

TorarAbu

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

$115 USD trong 3 ngày
(2 Đánh Giá)
2.3

27 freelancer đang chào giá trung bình $160 cho công việc này

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 trong 0 ngày
(664 Nhận xét)
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 Thêm

$180 USD trong 7 ngày
(443 Nhận xét)
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 Thêm

$257 USD trong 10 ngày
(24 Nhận xét)
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 Thêm

$166 USD trong 2 ngày
(81 Nhận xét)
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 trong 3 ngày
(402 Nhận xét)
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 Thêm

$200 USD trong 3 ngày
(79 Nhận xét)
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 Thêm

$155 USD trong 3 ngày
(17 Nhận xét)
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 trong 3 ngày
(82 Nhận xét)
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 trong 1 ngày
(72 Nhận xét)
6.1
$155 USD trong 3 ngày
(15 Nhận xét)
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, Thêm

$123 USD trong 3 ngày
(69 Nhận xét)
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 Thêm

$155 USD trong 3 ngày
(18 Nhận xét)
5.2
$55 USD trong 1 ngày
(38 Nhận xét)
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 Thêm

$155 USD trong 3 ngày
(6 Nhận xét)
4.9
$166 USD trong 2 ngày
(5 Nhận xét)
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 Thêm

$155 USD trong 3 ngày
(8 Nhận xét)
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 Thêm

$155 USD trong 1 ngày
(14 Nhận xét)
4.5
$244 USD trong 3 ngày
(3 Nhận xét)
3.5
$155 USD trong 3 ngày
(4 Nhận xét)
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 Thêm

$277 USD trong 3 ngày
(5 Nhận xét)
3.3