[AccessD] Record Maximum

Gowey Mike W Mike.W.Gowey at doc.state.or.us
Tue Oct 31 08:21:27 CST 2006


Thanks guys for your input.  I was just looking for some ways to explain
to the customer that the rumor that they heard about Access databases
crashing when the size of the database reached over 100mb.  I already
explained that this was a vicious rumor and explained to them how it
works, but they were not totally convinced so I was looking for more
amminition to though at them to eleviate their concerns.

Thanks again 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
Hindman
Sent: Monday, October 30, 2006 5:36 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
> 



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list