PHP/MySQL Optimization and customization expert for custom Instagram script

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.


: 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.

Evner: CSS, Databehandling, Database Administration, MySQL, PHP

Se mere: vps optimization, speed optimization, optimize mysql, instagram post, instagram API, database optimization, mysql performance optimization, optimize php code, optimize server speed, need instagram expert, fluent php, php instagram, php mysql optimize, mysql optimizing , instagram user, notifications php, optimization database, expert vps, custom instagram api, mysql server performance

Om arbejdsgiveren:
( 31 bedømmelser ) MIAMI, United States

Projekt ID: #4718729

Tildelt til:


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 på 1 dag
(9 bedømmelser)

9 freelancere byder i gennemsnit $651 på dette job


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 Flere

$463 USD in 3 dage
(178 bedømmelser)

Expert here. Kindly check your PM.

$500 USD in 3 dage
(305 bedømmelser)

Hi. We have the experience working with large databases, but not with instagram. But i sure we can explore it. Experience with php/mysql over 7 years. Hope to hear from you. With the best wishes, Slava.

$663 USD in 10 dage
(84 bedømmelser)

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

$400 USD in 2 dage
(186 bedømmelser)

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 in 20 dage
(16 bedømmelser)

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 Flere

$721 USD in 14 dage
(5 bedømmelser)

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

$380 USD på 1 dag
(23 bedømmelser)

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

$750 USD in 3 dage
(2 bedømmelser)