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 <chriswhite@stripped> wrote:
> 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
> converted to a timestamp storage wise and would become an indexable integer.
> Even 1,000,000+ rows shouldn't have that much of an effect. You'll also have
> the nice functionality of MySQL's date/time functions.
>
> --
> Chris White
> PHP Programmer
> Interfuel
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
