Correct sql query written for mysql to do the same faster (optimization)

已关闭 已发布的 Feb 5, 2016 货到付款
已关闭 货到付款

Attached are 2 sql sample queries that need to be optimized. The query takes over 10 sec. and up to complete. It is run when client goes to the website and selects a category tree (product category tree).

MySQL Nginx PHP Smarty PHP

项目ID: #9567171

关于项目

10个方案 远程项目 活跃的Mar 13, 2016

有10名威客正在参与此工作的竞标,均价zł83/小时

techwelfare

Dear Sir we are capable of performing the required task perfectly with accuracy, please let us know if you want to clarify in details.. if you want us to share our skill and previous work please initiate the chat b 更多

zł162PLN 在1天里
(106条评论)
6.6
JMeng16

dear sir. How are you. I have read your job description. and took an interest in your work. I have a experience of website designing and developing for 4 years. I offer a wide range of services, including Web desi 更多

zł95PLN 在1天里
(5条评论)
3.3
phiona06

I saw queries and I think need create index in field it.f_category and in field that participate in joins.

zł75 PLN 在0天内
(1条评论)
0.8
zahari84

A proposal has not yet been provided

zł85 PLN 在2天内
(0条评论)
0.0
dtrn

Hi! I'm an experienced DBA and I can clearly see the problem in your queries. (You can see I just got 93% on my first SQL course on here!) Of course I also know a solution. I can likely finish this in 2-3 hou 更多

zł50 PLN 在2天内
(0条评论)
0.0
gocebnte

I saw the code in your sql queries and i think it could be a lot better . You have unnecessary joins and very bad 'where' part. You just need to give me some additional information. Contact me Goce

zł75 PLN 在3天内
(0条评论)
0.0
ankimathur

Hi, I am a Microsoft Certified Engineer with 8 years of work experience and expertise in optimization. This is a search type query. I have done this before and have a technique of short circuit OR to optimize this 更多

zł75PLN 在1天里
(0条评论)
0.0