MySQL slow query need optimised

I have a new theme I've had designed. In it a custom post has an archive page which makes some custom queries for posts.

The posts are a custom post type called events and the event dates are stored in the database in wp_postmeta

The query they are using to find posts between or on certain dates are extremely slow. 80 seconds roughly.

I know where in the theme the queries are called, I just need to get the slow queries operating fast and make sure that the page load and the filter queries all work quickly in a bearable manner.

Beceriler: MySQL, WordPress

Daha fazlasını gör: wordpress slow, wordpress custom posts type, wordpress load posts, load posts wordpress, wordpress mysql query, query page, wordpress filter post, wordpress slow queries, wordpress archive custom, slow queries, queries wordpress, mysql query slow, mysql slow queries, fast load wordpress theme, mysql slow, slow mysql queries wordpress, mysql queries using, wordpress query database custom, mysql work slow, custom post type archive wordpress, wordpress theme events, custom post archive, wordpress filter posts, wordpress events theme, wordpress mysql load

İşveren Hakkında:
( 5 değerlendirme ) Dublin, Ireland

Proje NO: #6548024



Hi Please pick me on this project. I have some experience in optimizing wp_postmate and wp_post tables. All the best Alexei

%selectedBids___i_period_sub_7% gün içinde 155%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(47 Değerlendirme)

20 freelancers are bidding on average $130 for this job


Hi sir, i have read description and checked carefully the attach file. I know exactly the way to solve this job. please give me more information about project so that i can start right now. I'm really interested in thi Daha Fazla

in %bids___i_period_sub_35% gün içinde157%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(193 Değerlendirme)

hi sir thank for project i m very well experienced in word press designing and plug ins developing as well psd to wordpress i had done many fixes on the sites too i had developed plug ins like search , categories s Daha Fazla

in %bids___i_period_sub_35% gün içinde105%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(146 Değerlendirme)

Hello!! Here is our bid as your project details, we wants to work with you.**This is our initial bid** Please review our previous work on this URL [url removed, login to view] Please open message board to discuss in detail ab Daha Fazla

in %bids___i_period_sub_35% gün içinde34%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(51 Değerlendirme)

Hi sir, My name is Leonardo Medina, and I´m from Brazil. I have lots of experience in PHP. Please drop me a line, so we can discuss this project in details and I can make a proper bid. I'm an experienced Web D Daha Fazla

in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(66 Değerlendirme)

Hello. I'm a fulltime freelancer. Ready to start your project. I'm here now and we can discuss. Thank you very much.

in %bids___i_period_sub_35% gün içinde147%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(55 Değerlendirme)

Dear Sir. We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Daha Fazla

in %bids___i_period_sub_35% gün içinde178%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(30 Değerlendirme)

hi, i'm 15+ years experienced with strong knowledge of API integration and php with mysql, Plugin development and designing see my few portfolio **CSM and eCom** Magento / zencart / nopCommerce / drupal Daha Fazla

in %bids___i_period_sub_35% gün içinde106%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(28 Değerlendirme)

Dear Sir, I am ready to optimize the query to get fast result. I will provide you professional output with best quality. I have 7 years experience in web development. Please consider my job application and give Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(45 Değerlendirme)

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(18 Değerlendirme)

Hello There I think I can help you to do this DB task. Please provide me the details and we can go ahead. Hoping to hear back from your side. Thanks

in %bids___i_period_sub_35% gün içinde77%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)

Hi, I am an expert MySQL DBA and an optimization expert. I have a vast experience in dealing MySQL servers. I am a tech speaker and a MySQL Blogger too ( [url removed, login to view]). I can tune your MySQL querie Daha Fazla

in %bids___i_period_sub_35% gün içinde60%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)

Hello, Yes I am ready to do this job, Let's chat so that i can deliver you project with in a given time & promise that deliver you best service. Thanks [url removed, login to view]

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(13 Değerlendirme)

pm me fore more details pm me fore more details pm me fore more details pm me fore more details pm me fore more details pm me fore more details pm me fore more details Upfront payment : 31 usd ! Thanks !

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

6+ years experience in Linux Server Administration, extensive experience in installing, configuring, maintaining and troubleshooting Linux boxes, Apache, ApacheTomcat, Jboss, Exim/Qmail/Postfix, MySQL/PgSQL, security s Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(5 Değerlendirme)

Hello, I have expertise in database. In my profile maximum projects are database related only. I have 3+ years of experience in php and mysql. I am a Oracle certified associate.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)

use joins ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)

Expirienced developer with full time work in [url removed, login to view] We provide solutions for companies that handle big data (like telecomunication companies, banks and large archives), so my everyday work is optimisation of que Daha Fazla

in %bids___i_period_sub_35% gün içinde160%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I am an experienced SQL Developer who has coded 6 pages long queries and could optimize them as well.

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

hi, I fully understand with your requirements. i have good experienced with sql. look free my profile pages. let me know if you're interested working with me. cheers Denny Wu

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)