I always contact my hosting to find problems with my site and here is the review
Hi,
We don't see the queries fixed. There are still mainly two 'slow' queries which negatively affect your website's performance, as follows:
1.
# Query_time: 1.731232 Lock_time: 0.000127 Rows_sent: 1 Rows_examined: 1030836
use taffixbi285kce7q;
SET timestamp=1463209117;
select *, count(distinct views.views_id) as ViewCount from campaigns left join views ON views.views_campaign_id = campaigns.campaigns_id left join rates on rates.rates_id = campaigns.campaigns_rates_id where campaigns.campaigns_budget_used_today < campaigns.campaigns_daily_budget and campaigns.campaigns_current_budget > 0 and campaigns.campaigns_approved = 1 and campaigns.campaigns_status = 0 and campaigns.campaigns_payment_accepted = 1 and campaigns_device = 1 or campaigns.campaigns_device = 0 and rates_location = '' or rates.rates_location IS NULL group by campaigns.campaigns_daily_budget having ViewCount <= campaigns.campaigns_ordered_views * 1000 order by campaigns.campaigns_daily_budget asc;
2.
# Query_time: 0.771863 Lock_time: 0.000030 Rows_sent: 515420 Rows_examined: 515420
use taffixbi285kce7q;
SET timestamp=1463209114;
select * from views;
The query at the provided screenshot is different, "select * from views limit 0, 30". It uses 'limit', returns just 30 rows and takes 0.6ms to complete, while the query used by your script selects all the 515,420 rows, for some unknown reason, and it takes much longer, more than 700ms. It is hard to think of any reason why the script needs to download the whole table from the database, and it seems like a poor script implementation which should be fixed.
We see both queries very frequently, like about 1-2 queries per second on average. Taking into account the current level of traffic at your site (1-4 requests per second), it means that almost every request to the site results in running a code which executes one of the queries, and is slow because of that. That is a serious performance flaw in your script and hopefully your developer could fix it.
Hello
I need phpmyadmin access before we start - to analyse situation
My work plan is -
1- analyse database structure and queries
2- doing backup
3- optimize database structure and indexes
After that we'll see how good it works.
Also I want to ask You if You know - is it normal that so often is done the same queries?
And also - do You have access to manage mysql configs? Or ssh access? Or it is simple hosting with no possibilities configure the server?
Thanks
Hello,
I see that your mysql db is taking way too long to respond because of the amateur coding involved. I can help you fix this and write efficient code to make sure the query is processed in a very short time(negligible).
I am a web developer and have been developing websites for the past 4 years now.
I assure you that if you award me the project, I will complete it within the specified time meeting all your project requirements.
I invite you to further discuss your project with me.
Do consider my bid for this project.
I will be waiting for a reply.
Regards,
Morfsys
PS: You can click on my name to check what my clients say about me.
Hi there,
Read the details and are confident to fix both the queries for you and are ready to start right now.
Ping us to discuss the details now.
Regards!
ProWebTechnos
always contact my hosting to find problems with my site and here is the review
Hi,
We don't see the queries fixed. There are still mainly two 'slow' queries which negatively affect your website's performance, as follows:
1.
# Query_time: 1.731232 Lock_time: 0.000127 Rows_sent: 1 Rows_examined: 1030836
use taffixbi285kce7q;
SET timestamp=1463209117;
select *, count(distinct views.views_id) as ViewCount from campaigns left join views ON views.views_campaign_id = campaigns.campaigns_id left join rates on rates.rates_id = campaigns.campaigns_rates_id where campaigns.campaigns_budget_used_today < campaigns.campaigns_daily_budget and campaigns.campaigns_current_budget > 0 and campaigns.campaigns_approved = 1 and campaigns.campaigns_status = 0 and campaigns.campaigns_payment_accepted = 1 and campaigns_device = 1 or campaigns.campaigns_device = 0 and rates_location = '' or rates.rates_location IS NULL group by campaigns.campaigns_daily_budget having ViewCount <= campaigns.campaigns_ordered_views * 1000 order by campaigns.campaigns_daily_budget asc;
2.
I am having 8+ years of experience in designing and developing corporate websites and web applications. I have designed & developed a wide range of website using PHP mysql, wordpress, joomla, magento HTML, CSS, jQuery, JavaScript, Bootstrap, WordPress & Website design, PSD to HTML, My SQL.
Regards!
satyajeet