Annulé

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

16 freelance ont fait une offre moyenne de 195 $ pour ce travail

lokeshvvw

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
(142 Commentaires)
6.5
maxpl

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
(28 Commentaires)
6.6
rexzetsolutions

A proposal has not yet been provided

155 $ USD en 1 jour
(138 Commentaires)
6.2
appleofficer

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
(36 Commentaires)
5.6
imranahsan1

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
(45 Commentaires)
5.1
vlad70

Dear Sirs, each project unique, but You can check some project in my profile. one of them from UK event search system (777USD) - look similar with Yours I not expert in MongoDB or other NoSQL, but for MySQL gene Plus

250 $ USD en 3 jours
(16 Commentaires)
5.0
karlheinz

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
(26 Commentaires)
4.7
DevRk

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
(7 Commentaires)
3.8
srflipmedia

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
(13 Commentaires)
3.8
sushmakargwal

A proposal has not yet been provided

200 $ USD en 3 jours
(8 Commentaires)
3.7
DanielRed

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
(1 Commentaire)
2.1
poojafdo

A proposal has not yet been provided

222 $ USD en 3 jours
(0 Commentaires)
0.0
Majed09

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)
0.0
dshrestha06

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)
0.0
mongoar

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)
0.0
deepakgautam31

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
(0 Commentaires)
0.0