List:General Discussion« Previous MessageNext Message »
From:Dan Buettner Date:November 28 2006 3:21pm
Subject:Re: Re: One big table or several smaller tables?
View as plain text  
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
>
>
Thread
One big table or several smaller tables?Daniel Smith27 Nov
  • Re: One big table or several smaller tables?Chris White27 Nov
    • Re: Re: One big table or several smaller tables?Dan Buettner28 Nov