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
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?
The kind of situation I have in mind is a database of events during a
year, this table could top 1,000,000 enteries on the vague kind of
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