I need to improve search query in MySql, i do a query thru a single database and like 4 tables. Each table contain up to 5000 rows. When I do a search using php I get results in aprox 10-15 sec. I need it to be very fast, like 1-3 seconds. Code bellow:
<<$query = "SELECT * FROM `dosare` WHERE (`nr_dosar` LIKE '%".$search."'
or `id_clnt` in (select `id_clnt` from `client` where `nume` LIKE '%".$search."')
or `id_clnt` in (select `id_clnt` from `client` where `prenume` LIKE '%".$search."')) and `test` = 'NU' order by `id_dosar` DESC ";>>
17 freelanceria on tarjonnut keskimäärin $31 tähän työhön
Hello, As an expert in SQL, I am very much interested to do this project. I have checked the query and certainly I can optimize this for speed. Looking forward to have a positive response from you. Thanks
I can efficiently improve performance of required query because I am highly qualified SQL developer with more than 10 years of advanced experience and with exceptional expertise in professional SQL performance tuning.
Hi I have 15 years of experience in SQL server Database development,C# and python programming. I will be able to help you with the project. please ping me offline to discuss further.
hello, thanks for explanation can't wait to tweak on the code right now feel free to check my reputation in my profile page or my portfolio in [login to view URL] best wishes - wandi
Hello! I’m a post-graduated database administrator with 11+ years of experience. If you could send me the script for the tables creation and data inserts, I’d like to help you with this query.