Size of DB - Do too many rows cause a problem?

[Gregory.Spencer]

Hi there,

What is big for a MYSQL DB. E.g. I am working on someone elses DB that
has a many-many link table that notes what emails are sent out to what
users. Therefore each time a message gets sent out from this
application, if it got sent to 500 users for example, 500 rows would be
added to this table. If the amount of users was something like 10,000
then each time they were all mailed this would be 10,000 rows added. It
is already at 250,000 and as the new maintainer of the DB should this
be someething I should worry about?

Thanks

[steve]

"Gregory.Spence r" wrote:

Hi there,

What is big for a MYSQL DB. E.g. I am working on someone elses
DB that
has a many-many link table that notes what emails are sent out
to what
users. Therefore each time a message gets sent out from this
application, if it got sent to 500 users for example, 500 rows
would be
added to this table. If the amount of users was something like
10,000
then each time they were all mailed this would be 10,000 rows
added. It
is already at 250,000 and as the new maintainer of the DB
should this
be someething I should worry about?

Thanks

What can break is not the size of the table, but the size of the
indecis getting big. If indecis get very big, they cause problems in
updates (although can easily be repaired). So make sure you have
minimal indexing, just the minimum to allow the queries needed on this
table.

If the info is just kept for archival purposes, why not just write the
data to one big text file.

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/mySQL-Size-D...ict218341.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=750433