--- Brent Baisley <[EMAIL PROTECTED]> wrote: There are advantages to one large > table over many > smaller tables. A large table will take advantage of > query caching > better (if you have query cache enabled). Lots of > smaller table would > probably cause the query cache to get flushed more > often.
OK, thanks. I don't foresee my database growing to over 200 tables in the near future. How do I determine if I have query cache enabled? __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]