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!
11 фрилансеров(-а) готовы выполнить эту работу в среднем за €57
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
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.