Closed

MYSQL Database Optimization

This project was awarded to lfagundes for $21.25 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$30 - $40 USD
Total Bids
8
Project Description

I need a simple MYSQL database solution. I have a database that is 250MB in size, and I need to split this into 10 smaller databases to quicken the reponsiveness of data retreival. The makers of the database (at least the data in the database, which is just all IP addresses of countries) said I can easily just do this: You can speed up the query by splitting the database into smaller tables. For example, by split up the database into two smaller tables A and B will reduce query time by more than half. However, the query syntax need to know which table to look for instead. It can be done in the script level before form the sql query syntax. Psedocode if visitor ip number < begin ip number of table B then table = A else table = B end if sql = SLECT * FROM table WHERE ip number BETWEEN ipFROM and ipTO However, they said splitting to 10 smaller one's would be evenj better. That's it. That's all I need. Thank you Mick

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.


2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

.

Looking to make some money?

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

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online