I need to improve sql search result time


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 ";>>

Taidot: MySQL, PHP, SQL, JavaScript, Tietokannan hallinto

Näytä lisää: improve sql query time oscommerce, sql search result result, hello all i need is 90 into my skrill acount bcuze i cant withdrall my, i need a data entry part time job, i need a sql coder, i need a sql programmer, i need qlikview developer as part time in india, i need someone to search for movie names through a website visit the link get the embed code and submit it on my website i need , i need web developer for part time, i need a phd research proposal writer who can write 3 4 research proposals on potential phd research topics in the following are, i need to hire a help desk technician from india, need for speed most wanted savegame editor for 1.3 free download, I need a clean and professional logo for our service company in Europe. We have a app, where people can simply book any kind for, I need a native English speaking writer for long term -- 3, I Need USA wholesalers Price List\ s at-least \ 100\ With UPC Code, Cost, And Description + Each Company\ s Contact Info Compan, do i need a visa to travel to china from us?, do i need a visa to go to germany from usa, do i need an import license to buy goods from china, do i need a visa to go to japan from usa, i need a second job part time

Tietoa työnantajasta:
( 0 arvostelua ) Craiova, Romania

Projektin tunnus: #29371534

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

$30 USD 0 päivässä
(284 arvostelua)

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...

$29 USD 1 päivässä
(63 arvostelua)

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.

$40 USD 1 päivässä
(45 arvostelua)

Hello i am expertise in sql queries and mysql i will fix ur query to frtcg in quick time as u expected ping me

$35 USD 1 päivässä
(19 arvostelua)

Hello I have just read your job description. I'd like to solve your problem. I can start work right now. Egor Tokar

$30 USD 1 päivässä
(8 arvostelua)

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ää

$30 USD 7 päivässä
(1 arvostelu)

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ää

$25 USD 1 päivässä
(7 arvostelua)

Hello there, I will make your query faster assign me a project after your work is done. Portfolio: Thanks.

$10 USD 2 päivässä
(1 arvostelu)

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.

$13 USD 1 päivässä
(2 arvostelua)

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

$10 USD 1 päivässä
(3 arvostelua)

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.

$111 USD 4 päivässä
(1 arvostelu)

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

$11 USD 1 päivässä
(0 arvostelua)

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ää

$56 USD 7 päivässä
(0 arvostelua)

Professional skills : PHP , MySql with more than 5 years of experience. Query optimisation is very critical for my projects.

$20 USD 3 päivässä
(0 arvostelua)

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.

$30 USD 1 päivässä
(0 arvostelua)

Your SQL is correct. But you require additional SQL command to retrieve the data efficiently and quickly.

$30 USD 1 päivässä
(0 arvostelua)

I have around 15 years of experience in database performance tuning. You can change the query to SELECT * FROM 'dosare' WHERE ('nr_dosar` LIKE '%".$search."' or `id_clnt` in (select `id_clnt` from ` Lisää

$20 USD 7 päivässä
(0 arvostelua)