MySQL Limits?

sde · 05-14-2003, 10:48 AM

i'm doing some research on how much and how efficient mysql can be .. the goal is to be able to handle a contact database of over 1million .. full name , address, email, notes, etc ..

anyone know the limits of mysql? at the same time i'll be research pgsql.

Admin · 05-14-2003, 03:39 PM

1 million shouldnt be a problem.

we had something like 800,000 entries into a table, just make sure your queries are written well.

zulu · 05-30-2003, 08:02 PM

I have a MySQL db running with over 20,000 tables, up to 1000 rows per table... it holds up fine.

_adam

randy · 05-31-2003, 07:41 PM

Quote:

I have a MySQL db running with over 20,000 tables, up to 1000 rows per table... it holds up fine.

I use MySQL for every site I develop for and since they are actually low traffic compared to most I really didn't give the size much thought, but wow. That gives me a lot more confidence in my choice of databases.