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

date posted 24th July 2007 00:41


----- Original Message -----
From: "Dom Latter" [EMAIL REMOVED]
>
> On Monday 23 July 2007 22:52:40 Juraj Seffer wrote:
> > Because if I search for postcode "SW13 5JL", I know that I have to
> > search in table where I have postcodes from say O-S? Less rows to
> > index and search in, quicker query?
>
> You're just shifting part of the search from a highly optimised
environment
> (the database engine) to a very slow and clunky interpreted environment.
>
>

Yes, you're correct, although everybody seems to be drifting away from the
solution.

Horizontal partitioning is built in to the MySql engine, so handles the
partitions internally with impressive speed.

I'm currently working with a large (20 billion row) database & use
horizontal partitioning. It simply does the job


hth

JohnW