Re: FN-FORUM: How many rows can MySQL handle?

date posted 23rd July 2007 21:22

On Monday 23 July 2007 21:09:41 Gary Short wrote:
> Juraj Seffer wrote:
> > Evening all,
> >
> > Im working on a project where I would need to insert approx 26,700,000
> > (26.7 M) rows into one table using MySQL.
>
> Sounds to me like you need to horizontally partition the database. If it
> were customers for example you could partition A - M and N - Z (though
> for ~27M rows I'd have more than two partitions).

Why is many tables better than one?