Lukket

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

Evner: MySQL, PHP, SQL, JavaScript, Database Administration

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) Craiova, Romania

Projekt ID: #29371534

17 freelancere byder i gennemsnit $31 timen for dette 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 dage
(284 bedømmelser)
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 på 1 dag
(63 bedømmelser)
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 på 1 dag
(45 bedømmelser)
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 på 1 dag
(19 bedømmelser)
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 på 1 dag
(8 bedømmelser)
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 Flere

$30 USD in 7 dage
(1 bedømmelse)
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 Flere

$25 USD på 1 dag
(7 bedømmelser)
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 dage
(1 bedømmelse)
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 på 1 dag
(2 bedømmelser)
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 på 1 dag
(3 bedømmelser)
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 dage
(1 bedømmelse)
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 på 1 dag
(0 bedømmelser)
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 Flere

$56 USD in 7 dage
(0 bedømmelser)
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 dage
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
0.0
razmi65

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

$30 USD på 1 dag
(0 bedømmelser)
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 ` Flere

$20 USD in 7 dage
(0 bedømmelser)
0.0