PHP/MySQL Database Optimization

Budget $100 - $500 USD
Bids 8
Average Bid $278

We need a MySQL optimization specialist to help to improve the performance of an existing web statistics script that uses MySQL and PHP.

This project requires a deep knowledge of MySQL and PHP - we are not looking for someone to recommend just adding more indexes!

This is more a consultative role than a development role - we have our developers ready to implement any suggested changes, but do not have the required knowledge of MySQL optimization in house.


## Deliverables

1. Benchmarks/tests to judge script and database performance and bottlenecks

2. Complete list of suggested improvements to the script or database format detailing:
? ? ? A) What the change is
? ? ? ? B) Any specific syntax/commands (if required)
? ? ? C) What? this aims to improve
? ? ? D) How this will improve the specific area/bottleneck

While the? above deliverables are the only deliverables,? we are looking for someone who will work through these issues with us, and be available (at an negotiated rate) to assist us with the implementation of these suggestions.

Before bidding on this project, please be aware that any suggestions or code provided may be used as part of a commercial product.

We will also provide you with a copy of the product (and full source code) in confidence, which must be destroyed after the completion of the project.


## Platform

PHP and MySQL

Post a Project Like This

This project was awarded to

rossday

**If there were a 15 rating, I'd give it to Ross Day.** He is without question "Senior" in his field: Experienced Very savvy Professional No-nonsense Tells it like it is Gets the job done No games Doesn't get much better. Do you ever feel like you spend 3/4 of your time answering questions that you have already answered? Not with Ross. He provides feedback, valuable contributions, works day and night and even refused to stop work on July 4th! **He provided EXACTLY what I wanted inspite of what I asked for.** **You will be thrilled with the results if you work with Ross.**
About the Freelancer
rossday Profile Picture

## BIO | **<u>Ross Day</u>** **<u>Web/Application Developer (.NET, PHP, ASP, Perl)</u>** | | | | **<u>Experience</u>** | | I have over 3 years of experience developing small-, medium-, and large-scale web projects in two very dynamic environments: at a medium-sized state University and at an Internet-based group travel company. I have designed and developed large public e-commerce sites as well as small-scale and large-scale intranet systems. Working alone or in teams, I have consistently shown my ability to quickly produce high-quality work. My personal skills are also excellent, and I am comfortable discussing projects and working with non-technical people. | | Web Developer - Truman State University - 3 years | | * Truman State University Press - Online Store - Served as Team Leader and Project Designer * Centrally-Administered Newsletter System - Large-scale Newsletter System - Solo Project * GoBulldogs Website - Truman Athletics Site - Adapted newsletter system to serve as news management for athletics | | Web/Application Developer - Adventure Student Travel / Exploring America - 1 year | | * Developed many local intranet applications to reduce office paperwork, automate business processes, and generally increase the speed and efficiency of the business. * Develop large-scale system to manage the quoting, building, and selling of trip packages, including creation of quotes, itineraries, and agreements. * Serve as technical director, setting up and managing the business's servers for web, email, file/printer sharing, etc. | | | | **<u>Education</u>** | | * Bachelor's Degree in Computer Science and Mathematics from [Truman State University][1] * Graduated Cum Laude with a 3.58 GPA * Took a wide variety of computer science and mathematics courses including, but not limited to: Software Engineering, Artificial Intelligence, Parallel Processing, Internet Programming, Object-oriented Programming, Computer Graphics, Numerical Analysis, Methods of Optimization, and Number Theory | | | | **<u>Technical Skills</u>** | | * **Expert or Guru Level:** Access, AJAX, Apache, ASP, ASP.Net, Bash, C#, CSS, IIS, JavaScript, Linux, MS SQL Server, MySQL, Perl, PHP, VBScript, Windows, XHTML, XML * **Intermediate Level:** C, C++, Java, Oracle, Python, VB.Net | ## Area of Expertise | **<u>Ross Day</u>** **<u>Web/Application Developer (.NET, PHP, ASP, Perl)</u>** | | | | **<u>Knowledge/Expertise</u>** | | * Expert at writing dynamic Web Applications using ASP.Net(C#), PHP, ASP, and Perl. * Highly skilled at creating, analyzing, and optimizing databases incluing Access, MySQL, and Microsoft SQL Server. * Extensive knowledge of XHTML and CSS, including writing standards-compliant cross-browser sites without relying on hacks and tricks. * Expert at JavaScript, including advanced topics such as AJAX (XmlHttpRequest), drag-n-drop, and advanced form validation. * Intermediate level image editing. Able to create and modify basic logos. Able to clean and fix photos. * Excellent understanding of the principles of basic layout, colors, web standards, and accessibility. | | | | **<u>Technical Skills</u>** | | * **Expert or Guru Level:** Access, AJAX, Apache, ASP, ASP.Net, Bash, C#, CSS, IIS, JavaScript, Linux, MS SQL Server, MySQL, Perl, PHP, VBScript, Windows, XHTML, XML * **Intermediate Level:** C, C++, Java, Oracle, Python, VB.Net |

Looking to make some money?

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