Закрыт

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

Навыки: MySQL, PHP, SQL, JavaScript, Управление базами данных

Показать больше: 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

О работодателе:
( 0 отзыв(-а, -ов) ) Craiova, Romania

ID проекта: #29371534

17 фрилансеров(-а) готовы выполнить эту работу в среднем за $31

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 дней(-я)
(284 отзывов(-а))
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 день
(63 отзывов(-а))
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 день
(45 отзывов(-а))
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 день
(19 отзывов(-а))
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 день
(8 отзывов(-а))
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 Больше

$30 USD за 7 дней(-я)
(1 отзыв)
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 Больше

$25 USD за 1 день
(7 отзывов(-а))
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 дней(-я)
(1 отзыв)
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 день
(2 отзывов(-а))
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 день
(3 отзывов(-а))
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 дней(-я)
(1 отзыв)
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 день
(0 отзывов(-а))
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 Больше

$56 USD за 7 дней(-я)
(0 отзывов(-а))
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 дней(-я)
(0 отзывов(-а))
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 день
(0 отзывов(-а))
0.0
razmi65

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

$30 USD за 1 день
(0 отзывов(-а))
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 ` Больше

$20 USD за 7 дней(-я)
(0 отзывов(-а))
0.0