I need to improve sql search result time
Budjetti $10-30 USD
Hello,
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
Hi There, If Your issue haven't solved yet then I can help You to fix Your issue. If You are available now then ping me once please...
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.
Hello i am expertise in sql queries and mysql i will fix ur query to frtcg in quick time as u expected ping me
Hello I have just read your job description. I'd like to solve your problem. I can start work right now. Egor Tokar
Hi, The LIKE bits of the query are basically stopping indexes working. If you can, remove the % from the LIKEs and use your PHP website to query for a nr_dosar that you know exists. If the query is much faster, you k Lisää
Hi, I hope you doing well. I have 8 year experience in web development. I can optimise the query and speed up the result . I found the reason of query taking time. I can solve it. please give a chance to work with y Lisää
Hello there, I will make your query faster assign me a project after your work is done. Portfolio: https://www.freelancer.in/u/ajaykthakkar Thanks.
Hey, I would like to work on this. I am new in freelancer but have a great experience in MySQL and done this many times Thank you.
hello Sir, I have vast experience of building database in mysql. write any query which reduce time. hope you look forward to work with me. thank you
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
Hi, I am interested in this job. I am backend developer of magento 1.9 for [login to view URL] (fashion e-commerce) since 2016 until March 2020. I have developed custom api rest with mage query, custom core module (such as a Lisää
Professional skills : PHP , MySql with more than 5 years of experience. Query optimisation is very critical for my projects.
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.
Your SQL is correct. But you require additional SQL command to retrieve the data efficiently and quickly.
