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!

Skills: MySQL, PHP, Database Programming, SQL, Database Administration

See more: 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

About the Employer:
( 24 reviews ) Plauen, Germany

Project ID: #27452011

11 freelancers are bidding on average €57 for this job


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 More

€200 EUR in 1 day
(22 Reviews)

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 More

€200 EUR in 30 days
(42 Reviews)

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 More

€19 EUR in 7 days
(9 Reviews)

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 in 1 day
(17 Reviews)

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

€35 EUR in 1 day
(17 Reviews)

hello give me a chance

€19 EUR in 7 days
(2 Reviews)

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 in 2 days
(4 Reviews)

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 More

€25 EUR in 1 day
(1 Review)

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

€19 EUR in 1 day
(1 Review)

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 More

€20 EUR in 7 days
(0 Reviews)

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