PHP/MySQL Optimization and customization expert for custom Instagram script

Budget $250 - $750 USD
Bids 11
Average Bid $739

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.

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

Post a Project Like This

This project was awarded to

About the Freelancer

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • meet2amitvw Profile Picture

    meet2amitvw

    Ranip,  India

    Please check MY Repeat Hire rate as i believe in long term business relationships. Technical Details. =============== I have more than 10 years of experience in wide range of web & mobile designing and development services. We work as a committed full-time Freelancing team. I have expertise in all aspects of website design and development (including mobile) and have been involved in several small and large projects from the start to finish. Over the last 8 years, We have delivered hundreds of projects related to array of Web-Based Application, Mobile Based Application, Website Design, Software Architecture, API Development, Social Media Development, E-commerce Development, Social Media Integration, CMS Development etc. using the advanced and most appropriate web technologies. I work specially in PHP platform to bring the best possible end product. I have great experience in Open Source Content Management System like Drupal, Magento, Joomla, WordPress, .NET and MVC Object Oriented Framework such as Codelgniter, Zend, CakePHP, Qcodo, and PRADOTM for the startup and small businesses. Our other areas of expertise include E-commerce website and app with payment gateway integration; API Development with RestFul API (Protocol), OAuth1.0/2.0 (Facebook, Google, LinkedIn), SAML/SSO, OpenID, XML (SOAP) & WSDL; Mobile Development for iOS and Android; Social Media API like Facebook, Twitter, Google Analytics & Google Adwords Apps; Payment API like PayPal, authorize.net, Wepay. I also provide Software Design & Testing Service using various model-based approaches. Our core competency lies in complete end-end management of a new website development project, and I am seeking opportunities to build websites from the ground up for you or your business. I have the ability and confidence to bring innovation to your business that allows your company/organization to be a step ahead with the end products designed and developed by our small team as a freelancer at the professional standards. If you are a small or large business in need of new website or app or require any kind of digital resource, Please feel free to get in touch without wasting any single minute. I would love to work with you.

    PHP, Perl, ASP, and C Programming

  • josh002sl Profile Picture

    josh002sl

    NoVA,  United States

    Welcome. I've been building websites for 8 years now. I'm confident that your problem will be solved and you expectations will be exceeded. Guaranteed.

    PHP, Java, XML, and System Admin

  • darkerbg Profile Picture

    darkerbg

    Burgas,  Bulgaria

    Developer with 10+ years experience. I've done projects involving the following programing languages: PHP, JavaScript, Perl, VB, Pascal/Delphi, C and also some of the popular PHP, JS and Perl frameworks. Have also knowledge and experience in Graphic/Web design HTML5, CSS 2/3.

    Perl, Javascript, XML, and Script Install

  • slaviktim Profile Picture

    slaviktim

    Taganrog,  Russian Federation

    I'm a web developer, and I have experience in PHP, SQL, ajax, HTML5, Javascript (jQuery, Angular) and some related languages, for over 9 years. I like to work for both one-time and ongoing basis, and always ready to help with any issue in my expert area. I am experienced in developing applications and solutions for a wide range of corporate, charity and public sector clients and having the enthusiasm and ambition to complete projects to the highest standard.

    PHP, Javascript, XML, and Script Install

  • e3d Profile Picture

    e3d

    ST. PETERSBURG,  Russian Federation

    I'm an expert in web development and work as lead developer for one social media company since 2007.

    PHP, Java, Javascript, and Python

  • on2it Profile Picture

    on2it

    Bay of islands,  New Zealand

    Kiaora, welcome to on2itonline! on2itonline is a group composed of tech savvy individual's and marketing geniuses who banded together to get New Zealand, and the world, digitally engaged. We are about technology and how it can help you reach your maximum potential. We are a real company based in New Zealand. We are always looking to build the next big thing - are you it? If so, we would make a successful team! We develop websites, online stores, and Facebook pages (with stores too!) and much more. We are the 'go-to' guys for new software projects - anything goes at on2itonline! Your imagination is the limit. Not only we make innovative software, our hand-picked group of graphic artists make sure we produce classically beautiful, professionally attractive software, websites, Facebook pages, and Smartphone/iPhone applications. We produce quality work using responsive design technology to keep your website current well into the foreseeable mobile future.

    PHP, Java, Javascript, and XML

  • MHDJAZ Profile Picture

    MHDJAZ

    Algerie,  Algeria

    Quality , Time , Cost

    PHP, Javascript, Graphic Design, and Translation

  • WarrEagle Profile Picture

    WarrEagle

    St. Petersburg,  United States

    Experienced Application and Site Architect. I build custom solutions to modern problems using current web standards. Analytical in my approach to technical solutions. Very diverse set of talents. Web analytics, UI/UX, Back end design, development specializing in automation and user improvement. Google Analytics, tags, Adsense, Adwords. Amazon EC2, S3, Route 53, API LAMP, LEMP, MEAN stack experience as an architect for numerous projects. Node,js, Mongo DB, Apache, PHP, MySQL, Debian Linux, Windows. iOS Xcode, Yeah I can walk the walk. Hire me and we can talk about what i can do for you. 10 minute free consultation only. Senior level experience so PLEASE do not waste my time on tiny projects.

    System Admin, Wordpress, Marketing, and eCommerce

  • jthoma Profile Picture

    jthoma

    TRIVANDRUM,  India

    Started my career as a professional coder with the first project in dBase in 1987, and there was a career twist towards the end of 1989. Through 1997 I was more or less in the publishing industry and has worked in Alfajr UAE with the National Pink Pages and Oil and Gas Directory. Again a career twist took me through computer assembling, software, and trouble shooting. And towards 1998 got introduced to linux, system administration and by 2000 was into supporting cyber cafes to use linux on servers. Then again dropped into doing free lance jobs on freelance sites

    PHP, Javascript, System Admin, and Linux

  • joykeeper Profile Picture

    joykeeper

    Cambridge,  United Kingdom

    Have you ever entered a website and after few clicks given up just because you didn't find what you were looking for? It happens to everyone. If you want to attract customers they should immediately feel they are at right place on your website. I'm sure that smart and simple interface is the key to successful business. My solutions hide complex functionality under neat and friendly interface - this is my vision of an efficient product.

    PHP, Javascript, Website Design, and Graphic Design