On Mon, May 10, 2004 at 09:49:31PM -0700, Scott Haneda wrote: > Sorry for the post again, I hijacked a thread and wanted to get this on the > correct track. > > I can not seem to find the section in the manual that talks about the max > number of tables MySql can use, can someone point me please?
A classic hit is how efficient is your filesystem at handling large directories. Each table corresponds to a few files. Too many files in a single subdirectory can cause performance problems. I don't know if there's a limit at to how many tables can be handled by a single MySQL query. There are MySQL system variables that limit as to how big that query command can be. > ------------------------------------------------------------- > Scott Haneda Tel: 415.898.2602 > http://www.newgeo.com Fax: 313.557.5052 > [EMAIL PROTECTED] Novato, CA U.S.A. -- Brian Reichert <[EMAIL PROTECTED]> 37 Crystal Ave. #303 Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
