In Progress

MYSQL Database Optimization

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

.

Skills: Database Administration, Engineering, Linux, Microsoft, MySQL, PHP, Software Architecture, Software Testing, SQL, UNIX, Windows Desktop

See more: mysql query optimization software, mysql database software, speed optimization, Query optimization, mysql database , database optimization, table optimization, reduce sql, mysql number sql, php mysql sql example, sql reduce, mysql visitor program, simple program database, optimization database, mysql sql syntax, php mysql database query, reduce database size, mysql database query form, sql database size, simple php form mysql table, sql syntax, optimization software, mysql database php code, mysql visitor, script mysql query php

About the Employer:
( 12 reviews ) United States

Project ID: #3101762

Awarded to:

lfagundes

See private message.

$21.25 USD in 5 days
(13 Reviews)
3.9

8 freelancers are bidding on average $28 for this job

alexandrufl

See private message.

$34 USD in 5 days
(134 Reviews)
6.7
mihaiscortaru

See private message.

$30 USD in 5 days
(159 Reviews)
6.0
septsolutions

See private message.

$34 USD in 5 days
(21 Reviews)
5.1
datasage

See private message.

$21.25 USD in 5 days
(25 Reviews)
5.1
samuraisystemsvw

See private message.

$34 USD in 5 days
(34 Reviews)
4.4
crazybri

See private message.

$25.5 USD in 5 days
(10 Reviews)
2.8
andrewcrowe

See private message.

$25.5 USD in 5 days
(0 Reviews)
0.0