On Thu, 25 Sep 2003 [EMAIL PROTECTED] wrote:
> [...]
> Which is likely to be slower.
Wow!
> [...] Just give it lots of Ram so that it can cache its indexes in
> mamory, and it will perform very well.
Thanks for taking time to answer this.
Cheers,
Gerald
--
MySQL General Mailing List
For list
> Imagine I had a table with 50,000,000 rows, would it improve search
speeds
> if I split it up into smaller tables of 10,000,000 rows each? This means
> if I had to search for a record, I'd have to query the 5 tables one after
> the other.
Which is likely to be slower. If you have good indexes
