PHP/MySQL Optimization and customization expert for custom Instagram script

Slutfört Publicerat Jul 12, 2013 Betalades vid leverans
Slutfört Betalades vid leverans

I have a custom script that works with the Instagram API that sends notifications when subscribed users post a new picture. I need assistance optimizing the code and adding features. I require someone that speaks fluent english, and has experience working with large databases.

The database is a few hundred megabites, and the server makes millions of queries per day.

Programmer must have knowledge of Instagram and its API.

VPS: Xeon 2.5ghz 6 cores , 3gig Ram ,

Site: 800+ members, 50,000+ media entries DB Size 300mb

Problem: MySQL is consuming too much processing power. Every 10 min, the script crawls everyone's profiles to see the last 3 pictures posted. For each user, it then it checks the 50,000+ media ids to see if the 3 pictures exist. If not, they are considered new pictures, and they are then added to the db.

Needed*

: At least 3yrs Experience with PHP/Mysql

: Experience in Optimize PHP coding and Mysql DB's for performance and speed

: Prior work and experience with Large DBs

The script is very small. One page needs to be worked on. That is all.

CSS Databehandling Databasadministration MySQL PHP

Projekt-id: #4718729

About the project

8 offerter Distansprojekt Aktivt Jul 14, 2013

Tilldelades:

josh002sl

I have experience with large MySQL databases and query optimization. I imagine some database design changes will be needed but this script can certainly be optimized quickly.

$300 USD inom 1 dag
(9 omdömen)
3.3

8 frilansare har lagt bud på i genomsnitt $650 för det här jobbet

meet2amitvw

Please have look of my recent work based on api and web-services. i am my self developer not any company or agency so you can directly communicate with me. see my recent work for the technical expertise along wit Mer

$463 USD inom 3 dagar
(180 omdömen)
9.3
e3d

Expert here. Kindly check your PM.

$500 USD inom 3 dagar
(311 omdömen)
9.0
jthoma

I have been hacking with mysql and php for over 10 years now

$400 USD inom 2 dagar
(186 omdömen)
6.4
joykeeper

Hi, We're interested in your project and would like to work on it. I've sent you private message, please have a look.

$1684 USD inom 20 dagar
(16 omdömen)
5.1
on2it

Kia ora! on2itonline are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional experi Mer

$721 USD inom 14 dagar
(5 omdömen)
5.2
darkerbg

I've optimized several busy PHP/MySQL sites for speed

$380 USD inom 1 dag
(23 omdömen)
5.1
WarrEagle

----Check out your PM's for more details.-----

$750 USD inom 3 dagar
(2 omdömen)
2.9