Merge table Vs Big Table

[yobogs]

Hello,

First, sorry for my English

I have a Merge table with 70 millions lines (in 70 tables) and i insert 1 million line each week.

I use this merge table to insert, select and delete data.

I would like to know if it’s better for performance (insert and select, i don’t make many delete) to have 1 table with 70 millions lines or my merge table.

Tks for your help

[sterin]

Are you always selecting/inserting using the merge table and not the child tables?

Have you split out the child tables on different disks or are they all stored on the same disk?

If your answers are yes to the two above you will probably not notice any direct difference between using merge or just one large table.
In that case the load on the server is mostly dependent on the total size of the database and then it doesn’t really matter in what way the data i stored. The size is still the same and it is still as hard to search through.