Peter, Monday, October 14, 2002, 10:38:06 AM, you wrote: PS> Does anybody know whether it is possible for MySQL to handle round about 500-600 tables in one database or not (Win2k)? Where is the maximum?
PS> I want to work with dynamically created tables. Number of tables in the database is limited by file system: how many files that can be stored in one directory. If your tables are ISAM/MyISAM there will about 1500-1800 files in the dir. Seems, under NTFS you can have unlimited number of files (leaving alone performance questions;). As to FAT32 I don't exacly know, but I think more that 1800 files .. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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
