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
> scott@stripped Novato, CA U.S.A.
--
Brian Reichert <reichert@stripped>
37 Crystal Ave. #303 Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large
