Re: Multiple 1-1 tables better performance

Richard Lynch [EMAIL PROTECTED] wrote on 03/10/2005 05:13:09 PM: Apologies if this comes through twice... I *think* I fargled the To: the first time... My boss is claiming that having multiple 1-1 tables, with an index on the keys, is better performance. Example of his claim:

Multiple 1-1 tables better performance

Apologies if this comes through twice... I *think* I fargled the To: the first time... My boss is claiming that having multiple 1-1 tables, with an index on the keys, is better performance. Example of his claim: table_1: person_id, name, phone table_2: person_id, address, city, state, zip,

Re: Tables and performance

Yves Arsenault [EMAIL PROTECTED] wrote: Does a very large number of tables in a database affect MySQL's performance? Strictly saying, yes. But the difference won't really matter. So read - no, it won't affect performance. -- For technical support contracts, goto

Re: Tables and performance

Thanks for the reply. Yves On Tue, 19 Oct 2004 14:22:01 +0300, Egor Egorov [EMAIL PROTECTED] wrote: Yves Arsenault [EMAIL PROTECTED] wrote: Does a very large number of tables in a database affect MySQL's performance? Strictly saying, yes. But the difference won't really matter. So read -

Tables and performance

Hello, I have 2 questions. Is there a maximum number of tables that can be created in a database? Does a very large number of tables in a database affect MySQL's performance? Thanks, -- Yves Arsenault -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To