Limit to database entries?

[Neil Greenough]

I have a table that will be updated everymonth for 400 people and so there
will be 400 new entries everymonth. Subsequently, add the end of the year,
there will be 4800 entires / rows in the table. Will this cause any
problems? What will happen in 10 years time when there are 48000 entries?

 

[Tom Wickerath]

Hi Neil,

48,000 entries should be no problem, as long as you are not storing any BLOB (binary large
object) type data, such as embedded Word documents or pictures.

Tom
____________________________________


I have a table that will be updated everymonth for 400 people and so there
will be 400 new entries everymonth. Subsequently, add the end of the year,
there will be 4800 entires / rows in the table. Will this cause any
problems? What will happen in 10 years time when there are 48000 entries?

 

[Joseph Meehan]

I have a table that will be updated everymonth for 400 people and so there
will be 400 new entries everymonth. Subsequently, add the end of the year,
there will be 4800 entires / rows in the table. Will this cause any
problems? What will happen in 10 years time when there are 48000 entries?

The limit is based on the total size of the database. It was 1 gig in
earlier versions and it is 2 gig now. No specific limit for the number of
records.