Find Jobs
Hire Freelancers

DB MySQL Virtuemart Joomla 3.6

$30-250 USD

Cancelled
Posted over 6 years ago

$30-250 USD

Paid on delivery
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: [login to view URL] But pagese with products opens during 8 seconds +/- 5 seconds. For example, pages: [login to view URL] [login to view URL] [login to view URL] [login to view URL] I have made strace of one page: [login to view URL]%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%[login to view URL] According to strace, slow page speed is caused by 1208 SELECTs to database. You can check strace here: [login to view URL] 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/[login to view URL]' 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/[login to view URL]' 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/[login to view URL]' 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/[login to view URL]' AN _______________________________________________ Ребята, нужна помощь. Нужно протестировать сайт и понять, почему долго загружается карточки товаров. Страница, которая загружается с удовлетворительной скоростью: [login to view URL] Карточки товаров, которые загружаются долго: [login to view URL] [login to view URL] [login to view URL] [login to view URL] И все остальные. Если сможете понять причину, ожидаю и решение проблемы, по возможности. Хостинг предоставил следующую информацию: Произвели strace одного обращения к сайту по ссылке: [login to view URL]%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%[login to view URL] Судя по strace долгое время ответа сервера связано с большим количеством SELECT запросов в базу данных. При одном обращении к сайту происходит 1208 SELECT запросов в базу данных. Вывод strace положили в текстовом формате в корень домашнего каталога домена [login to view URL] (/var/www/intelli/[login to view URL]). Покажите этот файл разработчику сайта для оптимизаций кода сайта и оптимизации запросов при обращении к сайту. PS. Файл с анализом: [login to view URL]
Project ID: 15205587

About the project

25 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
25 freelancers are bidding on average $164 USD for this job
User Avatar
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 day
4.8 (746 reviews)
10.0
10.0
User Avatar
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 Joomla, Os-commerce,vBulletin ,Shopify, Bigcommerce, Magneto ,Zen cart-Drupal , android and IOS , I cancreate and deliver the project as per the information.I have skilled, expert programmers I'm very excited to assist you in making your Sites successful – please feel free to contact me directly to discuss this position further. Thanks
$180 USD in 7 days
4.7 (542 reviews)
8.5
8.5
User Avatar
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 Services, lighttp etc. I do my level best to make your site extremely fast. My expertise includes website performance optimization (front end optimization & back end optimization) for Virtuemart and Joomla site. I also have an extensive knowledge of Joomla Development so I am sure that I will be able to work on this. Looking forward for your positive response. Thank You..!!
$166 USD in 2 days
5.0 (180 reviews)
7.4
7.4
User Avatar
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, Redux framework, Gantry framework etc. Based on my expertise and long term experience, I can guarantee an extraordinary result within the anticipating time. I have keen experience in Wordpress, Wordpress theme customization, WordPress plugin development or modification. In my current and last job, I used to communicate in English with our client. I am comfortable to work in both fixed or hourly price. Let me know if you have any questions of concern & I will be more than happy to help you out towards finding your answer.
$123 USD in 3 days
4.8 (298 reviews)
7.8
7.8
User Avatar
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
4.9 (206 reviews)
7.6
7.6
User Avatar
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
4.8 (161 reviews)
7.5
7.5
User Avatar
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
4.8 (604 reviews)
7.5
7.5
User Avatar
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 14 of them are Mobile apps developers. Having said that we have built many of websites and Mobile applications. I look forward to working on this project as we can assign the team to handle this project. Check my work- https://www.freelancer.com/u/Shopify Regards Team Shopify
$257 USD in 10 days
5.0 (26 reviews)
6.9
6.9
User Avatar
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 of website development and mobile application. I have very good knowledge of how to make complete software requirement of the specification 3 milestone will be in the project please tell me best time when we can discuss project
$155 USD in 3 days
5.0 (44 reviews)
6.2
6.2
User Avatar
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 requirement in depth so that we both can be on the same page for a better product. Also I have few queries about your requirement so please open initial PMB and sort out my all doubts. Apart from this, You can go through over my profile and can check my reveiws and portfolio as well to get an better idea about my level of expertise. 5 Reasons why you should hire ME for your Work: 1. Available 24/7 upon your request 2. Delivery on-time with 100% satisfaction 3. Always think beyond boundaries and provide user friendly solution 4. Provide excellence with commitment 5. Most important, Free technical support for lifetime. Regards,
$155 USD in 3 days
4.8 (47 reviews)
6.1
6.1
User Avatar
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 etc. Initial Project Milestone
$155 USD in 3 days
4.9 (7 reviews)
5.0
5.0
User Avatar
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 Virtuemart Joomla 3.6 Relevant Skills: Joomla, MySQL, PHP, Virtuemart,
$155 USD in 1 day
4.3 (15 reviews)
4.8
4.8
User Avatar
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
4.8 (6 reviews)
3.2
3.2
User Avatar
#### 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 experience in joomla based websites design and development, solved similar issues for many client and also wants to work for you too. Please invite me on freelancer chat, I need to discuss on few points. Waiting for your positive reply. Thanks Abhishek
$100 USD in 3 days
0.0 (1 review)
0.0
0.0

About the client

Flag of UKRAINE
Kyiv, Ukraine
5.0
5
Payment method verified
Member since Nov 30, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.