How can i seperate large DB tables

split table with 3 million records into two smaller tables

[Kemal]

Hi i have a table which name is IPIS, and in this table there are 3 million+ records and i want to seperate this table to reduce query time. For example, in this table there ar Ip numbers and IPS informations, if we split the database into two tables. Table 1 has all records with IP number 0 - 20000000, meanwhile, Table 2 consists of all records with IP number 200000001 - 400000000.

[coopster]

Welcome to WebmasterWorld, Kemal.

Not sure we understand. Seems if you want to split the table, it is more than likely going to contain the same columns. Are you experiencing slow queries? Or updates? Can you offer more information regarding why you want to split the data?

[mack]

One thing that may be worth looking into is Mysql cluster. To be honest I have never used it but have done a little reading up in it.

From what I understand it spreads the load across several servers almost as if it was a single server with raid, but only cluisters the mysql processes and stored data.

This might be worth looking into in your case.

Mack.