max no of records in a table

[Mclaren]

Ok, so i have googled this q, but nothing comes up that is really informative.

I have just had a request to a a new function to the DB. This function will involve adding +- 15000 records DAILY to a table from a excel spread sheet. I am worried this will quickly overload the DB.

Suggestions ? maybe have two back ends, one for this specific table.....and one for all the rest ?

I don't wanna start coding until i am sure i am not gonna hit a brick wall very quickly.

Another thing i just thought of is maybe for the DB to on a daily basis export the current days records to a new table in a new DB to almost like an archiv e feature.

Again, any comment welcolm.

[RuralGuy]

This link should answer some of your questions: http://office.microsoft.com/en-us/ac...010341462.aspx

[John_G]

Hi -

I can only answer in general terms - a lot depends on what you want to do with the data. If there are, say, 150 characters per record, and you only add on working days, then 15,000 records per day amounts to about 560MB per year, and about 4M records - not really very many in the database world.

Keeping that large table in its own database would work fine. You are more likely to have problems with performance issues - can you tell us more about how the data will be used, i.e. queried on different fields, reports only, etc?

HTH

John