Re: Re: One big table or several smaller tables?

2006-11-28 Thread Dan Buettner
Daniel, you might look into the use of MERGE tables, which are essentially multipule identical MyISAM tables that look like one table. Dan On 11/27/06, Chris White <[EMAIL PROTECTED]> wrote: On Monday 27 November 2006 13:50, Daniel Smith wrote: > Assuming a decent spec server, would a simple s

Re: One big table or several smaller tables?

2006-11-27 Thread Chris White
On Monday 27 November 2006 13:50, Daniel Smith wrote: > Assuming a decent spec server, would a simple search query on a big > indexed table be quicker than searching the amount of data divided into > separate tables? I'd recommend a single large table with a DATE/DATETIME field which would be con