[AccessD] Record Maximum

...as JC pointed out, the "number" of records is rarely the driving factor 
...I'd add to JC's comments that the record length plays into the issue as 
well ...if each record is 2k its a major factor in your considerations.

...and while record count IS a factor in archiving, its not THE major factor 
...I baseline archive a record whenever it meets certain client specific 
milestones and only IF the client concurs on a record by record basis ...a 
dead record is a dead record whether there are 2K or 2M of them

William Hindman

----- Original Message ----- 
From: "Gowey Mike W" <Mike.W.Gowey at doc.state.or.us>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Monday, October 30, 2006 4:38 PM
Subject: [AccessD] Record Maximum


>
>
> Hi Everyone,
>
> Just a quick question.  What is the maximum or the most records that
> anyone has seen in a table before the database started to degrade in
> permormance.
>
> What would you consider the maximum record count before archiving?
>
>
> TIA for your thoughts,
>
> Mike Gowey  MCP, MCDST, MCSA, A+, LME, NET+
> Team Leader - SouthEast Region
> Information Systems Unit
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>