Suljettu

I need to improve sql search result time

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

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

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 0 päivässä
(284 arvostelua)
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 1 päivässä
(63 arvostelua)
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 1 päivässä
(45 arvostelua)
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 1 päivässä
(19 arvostelua)
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 1 päivässä
(8 arvostelua)
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 Lisää

$30 USD 7 päivässä
(1 arvostelu)
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 Lisää

$25 USD 1 päivässä
(7 arvostelua)
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 2 päivässä
(1 arvostelu)
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 1 päivässä
(2 arvostelua)
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 1 päivässä
(3 arvostelua)
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 4 päivässä
(1 arvostelu)
0.0
febriandiwandi86

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)
0.0
priadana17

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)
0.0
hitesh291

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)
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 1 päivässä
(0 arvostelua)
0.0
razmi65

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)
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 ` Lisää

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