On Sun, Nov 04, 2001 at 01:06:27AM +0100, florian wrote:
>
> im storing pretty big amounts of customer data in a mysql databases.
> its about 2 million rows. what im wondering about now is, how does
> mysql perform joins on such amounts of data?
>
> i was planning to split the info in at least 3
well. for now it can only be one contact and one address per
customer. the thing
is though, that also other people can have addresses and contacts. so
for example
there will be a user table or something like that. and a user will also have
address and contact information.
would you still rec
Well, you usualy split your data in tables for a reason, because some data in
mulitple numbers are associated to one, or multiple data.
In your case, if you have one address and contact per customers, then make it
one table.
If you have an unknown numer of contacts and numbers per customer, the
