Devam Ediyor

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ün: 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

Seçilen:

danale72

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

3 gün içinde 155$ USD
(47 Değerlendirme)
5.3

20 freelancer bu iş için ortalamada 130$ teklif veriyor

nkhuynh

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 fazlası

in 3 gün içinde157$ USD
(193 Değerlendirme)
6.7
mtthardy4

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 fazlası

in 2 gün içinde105$ USD
(146 Değerlendirme)
6.6
ssahilsl

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 fazlası

in 3 gün içinde34$ USD
(51 Değerlendirme)
6.5
leomedina01

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 fazlası

in 3 gün içinde222$ USD
(66 Değerlendirme)
6.1
dungnguyen2607

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

in 3 gün içinde147$ USD
(55 Değerlendirme)
5.9
VnBestSolutions

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 fazlası

in 3 gün içinde178$ USD
(30 Değerlendirme)
5.4
rsen75

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 fazlası

in 2 gün içinde106$ USD
(28 Değerlendirme)
5.2
mdmojman

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 fazlası

1 gün içinde 134$ USD
(45 Değerlendirme)
5.1
aryan151

A proposal has not yet been provided

in 3 gün içinde35$ USD
(18 Değerlendirme)
4.0
luminous15

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 6 gün içinde77$ USD
(8 Değerlendirme)
3.8
remotemysqldba

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 fazlası

in 0 gün içinde60$ USD
(4 Değerlendirme)
3.5
WorkRewards

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 3 gün içinde155$ USD
(13 Değerlendirme)
3.5
bupeherve

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 3 gün içinde155$ USD
(2 Değerlendirme)
3.0
fxdarius

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 fazlası

1 gün içinde 100$ USD
(5 Değerlendirme)
3.0
avinashjain09

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 5 gün içinde100$ USD
(10 Değerlendirme)
3.0
abapguru

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

in 3 gün içinde155$ USD
(5 Değerlendirme)
2.3
valras

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 fazlası

in 3 gün içinde160$ USD
(0 Değerlendirme)
0.0
omvineet

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

in 3 gün içinde155$ USD
(0 Değerlendirme)
0.0
dennywu

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 111$ USD
(0 Değerlendirme)
0.0
algobasket

A proposal has not yet been provided

in 3 gün içinde155$ USD
(0 Değerlendirme)
0.0