Ok, I'm not a MySQL guru, so i've got a question for all of you out there.
Is it more efficient to have 500 tables each with 18,000 records in them or to have one giant table with 9000000 (500 * 18000) records. Or is some other permutation the most efficient.
Thanks for your help.
~Matt
Is it more efficient to have 500 tables each with 18,000 records in them or to have one giant table with 9000000 (500 * 18000) records. Or is some other permutation the most efficient.
Thanks for your help.
~Matt