Terminé

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.

Compétences : Géolocalisation, MySQL, PHP

en voir plus : 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

Concernant l'employeur :
( 38 commentaires ) Beograd, Slovenia

Nº du projet : #18145677

Décerné à:

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 Plus

$25 USD / heure
(45 Commentaires)
5.8

35 freelance font une offre moyenne de $35/heure pour ce travail

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 Plus

$25 USD / heure
(788 Commentaires)
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 Plus

$35 USD / heure
(95 Commentaires)
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 Plus

$35 USD / heure
(1189 Commentaires)
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 Plus

$70 USD / heure
(108 Commentaires)
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 Plus

$44 USD / heure
(156 Commentaires)
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 Plus

$30 USD / heure
(240 Commentaires)
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. Plus

$25 USD / heure
(167 Commentaires)
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 Plus

$25 USD / heure
(135 Commentaires)
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 Plus

$33 USD / heure
(1716 Commentaires)
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 Plus

$40 USD / heure
(239 Commentaires)
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 Plus

$25 USD / heure
(178 Commentaires)
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 Plus

$41 USD / heure
(35 Commentaires)
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 Plus

$50 USD / heure
(140 Commentaires)
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 / heure
(63 Commentaires)
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 Plus

$27 USD / heure
(346 Commentaires)
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 Plus

$44 USD / heure
(27 Commentaires)
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 Plus

$40 USD / heure
(35 Commentaires)
6.7
creativeitechpvt

I m able to do this job

$29 USD / heure
(129 Commentaires)
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 Plus

$44 USD / heure
(62 Commentaires)
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 Plus

$50 USD / heure
(22 Commentaires)
6.1