Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Want to make sure I'm right
Message
 
To
26/09/2002 18:53:32
General information
Forum:
Visual Basic
Category:
Access
Miscellaneous
Thread ID:
00705013
Message ID:
00705017
Views:
9
I have never seen such an exact limit. Many factors impacts performance like indexes (you need some but not too much), the presence of a blob field (like an image), memo fields, the number of columns, the way you write your queries, the kind of interaction with the database (read only or read-write), the state of the database (compacted on a regular basis), ...


>I heard that if using MS Access it reaches more then 24,000 records that it becomes less efficient or that databse will run slower. Is this true?
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Previous
Reply
Map
View

Click here to load this message in the networking platform