Arvin Bautista wrote: > > I'm new to mysql/sql thing > > thus mysql can efficiently handles a database even it has a hundred tables >
Yes, but you need to make sure to set your table cache large enough to cache all these tables to stay fast. This is for MyISAM tables, the default. BDB supposedly doesn't scale well with very many tables, and InnoDB does not use the same table caching as MyISAM but should scale. These 3 table types represent different ways MySQL has in storing your data. InnoDB is the newest of the group & MyISAM is the oldest. ( ISAM is older but deprecated ). MyISAM does not scale as well to large data sets where there is a mix of reads & writes because it does not have a transactional engine. BDB seems to be a slower engine ( benchmarks?, haven't seen any ), but has been released for almost 2 years. InnoDB has been released for almost a year but is a much better engine than either MyISAM & BDB and would be worth a look if designing your database from scratch for sure. --Josh _________________________________________________________________ Joshua Chamas Chamas Enterprises Inc. NodeWorks Founder Huntington Beach, CA USA http://www.nodeworks.com 1-714-625-4051 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php