Completed

Tune the Geolocation Mysql Query

We are using geolocation on our website - we are using IP of the visitor to locate the timezone of the visitor and then we display content based on the timezone.

We are using a geolocation mysql table with 3M rows for this.

The site is working fine when we receive maybe up to 100 visitors per second, but when that goes up to say 200 the server cannot process the query fast enough and the whole server stops. Old processes are backing up and new ones are coming in faster than old ones can be processed.

I had a developer add this functionality and he is no geolocation expert. He added the table and used a basic query. By what I've had a chance to read online this is a common performance problem for everyone dealing with geolocation on a basic level. Since he has no experience on how to better tune this query to be faster, we need a geolocation expert that can check it out and see what can be done.

Skills: Geolocation, MySQL, PHP

See more: mysql st_transform, geolocation query mysql, mysql geofence, mysql geolocation data type, mysql geometry, mysql point query, mysql gps, st_distance_sphere mysql, project management, data entry, cms, banner creation, design, seo, php, android, marketing, mysql, css, html

About the Employer:
( 38 reviews ) Beograd, Slovenia

Project ID: #18145677

Awarded to:

karlheinz

Hello, Thanks for the invitation. "We are using geolocation on our website - we are using IP of the visitor to locate the timezone of the visitor and then we display content based on the timezone. We are using a More

$25 USD / hour
(45 Reviews)
5.8

35 freelancers are bidding on average $35/hour for this job

winmaclin

Hi vlab, After reviewing your job description, We can definitely help you to fix all existing issues in your existing website as per your needs with all necessary modification with required features and functionalit More

$25 USD / hour
(788 Reviews)
9.3
leadconcept

Hi there, I have read initial requirements & as per my understanding, you want to customize query which is using for geolocation data fetching. Here are my questions: - Can you please provide URL of your websi More

$35 USD / hour
(95 Reviews)
8.9
kabirchy

Hi there, I have checked your project brief very carefully and can help you on this. So far I understand that from IP you find user GEO location from database. Instead of a MySQL database there are 2 options 1. Using More

$35 USD / hour
(1189 Reviews)
9.2
devexpertsteam

Hello, We are always pleased to take part in the development of living products, which are created as an answer to real user needs. Looks like you have already went through a set of paths and processes including More

$70 USD / hour
(108 Reviews)
8.7
arhamsoftltd

Greetings, Hi, I am Senior Full Stack website developer having 14 years of experience in website development and designing. I have extensive knowledge of Core PHP and it's frameworks (Symfony, Laravel, Zend, CI, Cak More

$44 USD / hour
(156 Reviews)
8.9
shivmirthyusl

Hi There, Thank you for the opportunity You are using geolocation on your website which works fine when you receive maybe up to 100 visitors per second, but when that goes up to say 200 the server cannot process More

$30 USD / hour
(240 Reviews)
8.3
nuked24

Hi, please send me full project requirement details . you have any reference site url ? We are expert in designing as well in development. We will provide you quality of work. We will provide you our best. More

$25 USD / hour
(167 Reviews)
8.6
augurstech

Dear Employer, Hope you are doing Great..!! I have gone through your job posting and found our skills best suited for this project. I would be glad to let you know that our team already gained extensive experienc More

$25 USD / hour
(135 Reviews)
8.1
TakeReal

Hello, My name is Sergey. I am Freelancer from Saint Petersburg, Russia. I can help you to speed up the Geolocation MySQL Query. I need access to your code and to MySQL database. I hope to finish in 2-3 working h More

$33 USD / hour
(1716 Reviews)
8.0
akash9958

Hello There, I have gone through the work details you have posted and I see you are looking for a solution to accurately locate the user loading the website and show the content based on their location in bulk. S More

$40 USD / hour
(239 Reviews)
8.2
wpoppo

Hello, As per need, you wish to tune the Geolocation Mysql Query. we have shared our company portfolio please go through it: We have a team of professional PHP developer with an experience of more than 8+ years i More

$25 USD / hour
(178 Reviews)
8.3
WhizPool

Hello, Please let me know 1. Did you do mySQL profiling? 2. Did he apply indexing 3. What is query time for geo location? And if possible, can you provide read only access to the database. Only and Only More

$41 USD / hour
(35 Reviews)
8.2
hardcode4u

Hello, Hope you are doing well. My name is Ishant and I am an expert PHP & JS developer having experience of 9 years. I can do any type of development & customization work in PHP. I have gone through the project More

$50 USD / hour
(140 Reviews)
7.8
micheal4299

I can optimize your query as per your requirements. I am a geolocation expert that can check out the issue in your system and see what can be done. thanks!

$25 USD / hour
(63 Reviews)
7.4
coolguyinus2004

For 100 or 200 customers per second query a 3M table the whole Mysql and PHP will process it slow [login to view URL] me the site url and database access so i can plan for the work and discuss with you and work on it and fix it More

$27 USD / hour
(346 Reviews)
7.6
jpadula

Hi there, We are a team based in Argentina with strong experience in software and mobile development. We are able to do your project starting ASAP. Do not hesitate to contact me if you are interested. You will More

$44 USD / hour
(27 Reviews)
7.3
amjohn

Hi It's pleasure to meet you. I read complete project description and i understand the issue of geo location mysql query. We are certified web design and development company and working from last 7 years for client More

$40 USD / hour
(35 Reviews)
6.7
creativeitechpvt

I m able to do this job

$29 USD / hour
(129 Reviews)
6.9
snapycode

Dear Hiring Manager, Thank you for reviewing my [login to view URL] are many other ways to retrieve visitors IP and fetch the details based on that.I have built a custom site using own custom algorithm with multiple API More

$44 USD / hour
(62 Reviews)
6.9
james4uboda

Hi, I checked your JD and feel confident to optimize your sql query asap. You will be happy with my 12 years of experience and skills in MySql. What is your site url? I can start work right now. I would love a lon More

$50 USD / hour
(22 Reviews)
6.1