Correct sql query written for mysql to do the same faster (optimization)
zł30-90 PLN
货到付款
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).
项目ID: #9567171
关于项目
有10名威客正在参与此工作的竞标,均价zł83/小时
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 更多
I saw queries and I think need create index in field it.f_category and in field that participate in joins.
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
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 更多