I am designing a database right now that will have between 300-400k inserts per day. I need to keep this information for approximately 3 months and will probably do 5-10 reads on the data set per day. I've been storing it in one table up to now (only col.), but the searches are becoming more and more of a problem. I'd like to break it up so that I have one table for every day, and then I'll just delete the trailing days when I create a new day. So I would have 90 tables of roughly 350k records instead of a single table with 6+ million records. What do you al think of this design? I'm making an assumption that it will make my searches a lot faster for a single day (I doubt I would ever need to search on more than one day). Thanks!
Julian Zottl
Unix Systems Administrator
NASA HQ - 202-358-1682
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
