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

[Gregory.Spencer@lycos.co.uk]

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]

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

"Gregory.Spence r" wrote:[color=blue]
> 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[/color]

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