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 [url removed, login to view] 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.

Skills: CSS, Data Processing, Database Administration, MySQL, PHP

See more: 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

About the Employer:
( 26 reviews ) MIAMI, United States

Project ID: #4718729

Awarded to:


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 in 1 day
(7 Reviews)

10 freelancers are bidding on average $658 for this job


Expert here. Kindly check your PM.

$500 USD in 3 days
(61 Reviews)

Hi, Please check private message. Thanks

$1546 USD in 25 days
(33 Reviews)

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 More

$463 USD in 3 days
(54 Reviews)

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

$400 USD in 2 days
(175 Reviews)

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 days
(45 Reviews)

5 years experience in web development. PHP/MYSQL Expert.

$722 USD in 3 days
(30 Reviews)

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 More

$721 USD in 14 days
(5 Reviews)

Thanks for giving your precious time to review my bid and check PM! Thank you

$824 USD in 12 days
(10 Reviews)

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 days
(8 Reviews)

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

$380 USD in 1 day
(6 Reviews)

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

$750 USD in 3 days
(2 Reviews)