Performance /database optimization!

In our website we use different filters in search. One of them filters location (Zip / city) + radius (distance to a location). Radius is working according to requirements. It is filtering cars according to the radius calculated based on longitude and latitude. The code and query is already there. The issue is code is filtering cars very slow. We need fast and optimized queries that filter cars quicker.

It is required to optimize queries that fetch results quicker by joining the zip_coordinates table.

What is already done: The code for radius filtering already done. Required indexing is done. Function FN_GET_DISTANCE has been created on database server that takes longitude and latitudes and calculate distance but failed to achieve the speed required.

What we have tried: I have also tried a query that calculates points and then filters the records that have distance too away from the radius. In this way we will have only those points that lie within the radius or near to the radius. In this way, we have tried to lessen the speed but still it is slow.

Only advanced devs with huge experience in this field!!!

We have lot to do: If you are good and enjoy with us - join us!

Kemahiran: MySQL, PHP, Pengaturcaraan Pangkalan Data, SQL, Pentadbiran Pangkalan Data

Lihat lagi: mysql database optimization, phpbb3 database optimization, wordpress database optimization, what is performance tuning in sql, sql performance tuning tutorial, how to improve database performance in sql server, sql query performance tuning tips, database optimization techniques, performance tuning in dbms, performance tuning, performance tuning in sql server, joomla database optimization, performance joomla optimization, sql query check performance database, joomla performance database optimizing, joomla database optimization 2009, test case document performance database, magento database optimization, zen cart database optimization, android database optimization

Tentang Majikan:
( 24 ulasan ) Plauen, Germany

ID Projek: #27452011

11 pekerja bebas membida secara purata €57 untuk pekerjaan ini


Hallo, kann mir das ganze mal unverbindlich anschauen, an sich hab ich Erfahrungen mit Datenbanken die Millarden von Einträgen und > 100 GB sind, was man da wie machen kann, kann man aber erst sagen wenn man das Dat Lagi

€200 EUR dalam sehari
(22 Ulasan)

Hello Sir/Mam, I am full time developer and did many work so please come on chat and provide me once opportunity to start work and sure about quality and perfect work. How we will increase speed- * We will check cur Lagi

€200 EUR dalam 30 hari
(42 Ulasan)

I think that it it not problem related query optimization. It would be considered as db structure problem. I have no idea to be paid from you for this one. I will only consult for you free because I'd like to get more Lagi

€19 EUR dalam 7 hari
(9 Ulasan)

hi I have more than 10 years of professional experience in sql development and optimisation and worked in more than 300 projects in different database like Oracle,mysql/db2/ [login to view URL] discuss your requirements

€56 EUR dalam sehari
(17 Ulasan)

I am Senior SQL Developer with 10+ years experience and I can help to improve execution performance of 'FN_GET_DISTANCE' Function.

€35 EUR dalam sehari
(17 Ulasan)

hello give me a chance

€19 EUR dalam 7 hari
(2 Ulasan)

Dear bro. With 5 years experience working as data engineer I will help you speed up your filter. Let send me your queries, may be I can help you. Have a great day. Thank you.

€30 EUR dalam 2 hari
(4 Ulasan)

Friend! I would love to work with you on this project. I'm Database Developer & Accidental DBA; have 5+ years of extensive and expert level experience with Microsoft SQL Server (versions 2008-2019). I love SQL Server Lagi

€25 EUR dalam sehari
(1 Ulasan)

have resolved many DB and application related performance like this, happy to support in this case, if i get more details.

€19 EUR dalam sehari
(1 Ulasan)

HI I go through the description If you share the additional information it will help us to develop. Hands on developing windows based application,Web application with backend [login to view URL] on experience in developing f Lagi

€20 EUR dalam 7 hari
(0 Ulasan)

I am an SQL Server database administrator with experience in index and performance, I am new here so I want to try this job.

€8 EUR dalam sehari
(0 Ulasan)