I need to improve sql search result time

Closed Posted 3 years ago Paid on delivery
Closed 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 ";>>

MySQL PHP SQL JavaScript Database Administration

Project ID: #29371534

About the project

17 proposals Remote project Active 2 years ago

17 freelancers are bidding on average $31 for this job

sumon355

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 in 0 days
(284 Reviews)
7.7
ripasahasl

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 in 1 day
(63 Reviews)
5.3
SqlDevelopment

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 in 1 day
(45 Reviews)
5.3
sreenivas2903

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 in 1 day
(19 Reviews)
4.6
egortokar

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 in 1 day
(8 Reviews)
3.4
fchorley99

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

$30 USD in 7 days
(1 Review)
2.7
manuvelsubin

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

$25 USD in 1 day
(7 Reviews)
2.8
ajaykthakkar

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.

$10 USD in 2 days
(1 Review)
1.4
munishbhagat16

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 in 1 day
(2 Reviews)
0.7
amirgull

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 in 1 day
(3 Reviews)
1.4
bizmanas

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 in 4 days
(1 Review)
0.0
hitesh291

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

$20 USD in 3 days
(0 Reviews)
0.0
vtolentino3

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 in 1 day
(0 Reviews)
0.0
razmi65

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

$30 USD in 1 day
(0 Reviews)
0.0
sjain100

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 ` More

$20 USD in 7 days
(0 Reviews)
0.0