improve query response time for estimation

Our website offer an estimation to our customers but the loading time is very long. We use a mysql table with more than 1,200,000 row and the query use the distance location (using latitude and longitude). Now the loading time is around 90 seconds. So we want to reduce this loading time. We are thinking that you could improve the loading on 3 axes:

-improve the query to reduce calls

- indexing columns from our mysql database

- migrate to mongodb and use the location core function

we will study your proposal. More information given if needed during negociation.

Thank you.

Compétences : Javascript, MySQL, NoSQL Couch & Mongo , PHP

Voir plus : estimation time php matrimonial site, estimation time j2ee applications, vbscript elapsed time sql query, auto response query irc, perfectness joomla developed core database, migrate exchange 2007 database, est time mysql query examples, core database systems forum, migrate mysql vtiger database sugarcrm

Concernant l'employeur :
( 26 commentaires ) MIAMI BEACH, United States

N° du projet : #8470254

15 freelancers are bidding on average $191 for this job


15+ years on Magento ,Ecommerce & Web development Projects I am a software developer and life long techie who lives in New york. I have a broad range of experience and a passion for technology in business. I often Plus

410 $ USD en 3 jours
(80 Commentaires)

A proposal has not yet been provided

155 $ USD en 1 jour
(245 Commentaires)

Sir, at this stage i wouldn’t consider moving to mongoDB, if possible would like to check your existing db structure,script and query, will check indexes and will create any new if needed. will also check query a Plus

105 $ USD en 4 jours
(156 Commentaires)

Hi, We can discuss price and time frame for this project. I have 5+ years of experience in webdesign/ development, WordPress, OperCart, E-commerce, Mobile Development, SEO and I have done number of projects. I Plus

210 $ USD en 5 jours
(32 Commentaires)

we are understand your requirement . we have 5 + year experience in design & development so communicate with me . you can check my work on below URL: PHP web URL : [url removed, login to view] [url removed, login to view] ht Plus

108 $ USD en 5 jours
(49 Commentaires)

Hello, This bid is just a placeholder. I'm going to ask questions, clarify the details and then place a "real" bid. 1. Do you use a formula (like [url removed, login to view]) or a spatial r Plus

30 $ USD en 3 jours
(49 Commentaires)

We're professionals Web and Mysql development with more than 4 years of [url removed, login to view] have read your project description and it is honor for us to do you [url removed, login to view] can get quality work from us regarding this project. Plus

350 $ USD en 3 jours
(67 Commentaires)

I have almost 5 year exp in php, jquery ,codeigniter and zend.. yes, indexing made a great impact on speed .. There is some more thing to optimize table.. Please let me do this.. please hire me for this task

60 $ USD en 3 jours
(42 Commentaires)

A proposal has not yet been provided

200 $ USD en 3 jours
(18 Commentaires)

Hello, The loading time can be improve using the methods you describe. I suggest you the first two methods unless you really what to change the mysql database with a mongo database. If you choose to replace the da Plus

220 $ USD en 5 jours
(12 Commentaires)

A proposal has not yet been provided

222 $ USD en 3 jours
(0 Commentaires)

I have completed this type of projects in couple of companies. I am working as a web developer in an e-commerce company. I have an experienced team.

250 $ USD en 3 jours
(0 Commentaires)

Hello, I am Danish Shrestha, sr. big data software engineer at Windlogics, MN. I've been working with Mongo, Cassandra, Solr, hadoop for few years now. I have also given talks about spark in meetups in minneapolis met Plus

244 $ USD en 5 jours
(0 Commentaires)

Having 9+iyears of total experience in IT industry. - Having extensive experience in MySQL database development including thousands of stored procedures development and migration - Having extensive experience in migr Plus

155 $ USD en 3 jours
(0 Commentaires)

Our favorite area. We are expert in Web Design and PHP work. Have created lot of forums and community websites. Looking forward to your requirement. Ready to start asap at affordable rates.

151 $ USD en 3 jours
(1 Commentaire)