I need to improve sql search result time
$10-30 USD
Paid on delivery
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 ";>>
Project ID: #29371534
About the project
17 freelancers are bidding on average $31 for this job
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 More
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 More
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.
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.