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/[EMAIL PROTECTED]