Database Discussion

Print Page | Close Window

Access

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=7518
Printed Date: 28 March 2026 at 9:19am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Access

Posted By: Gullanian
Subject: Access
Date Posted: 23 November 2003 at 5:52am

Hey guys. I got an access DB with 2,000 records, its on a PC being used by a VB program. How long will it take to load 2,000 records up? (record data contains only two long integers, 8bytes total per record). It will be loading up 2,000 records a lot, so in total ill will be loading around 1,000,000 records in a day.... ohhh errr, is this ok?

Replies:

Posted By: michael
Date Posted: 23 November 2003 at 10:03am

Are you loading the records up via query or the whole mdb? It should not take to long for 2000 but in order to get to a MIllion you have 5000 people doing it every day, would not do that via DSL or Cable :)

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: Gullanian
Date Posted: 23 November 2003 at 11:04am

Its all client side, the database and program are on the same PC, no Internet involved, will it be ok?

Posted By: michael
Date Posted: 23 November 2003 at 8:15pm

You should be ok, I run 1M inserts of small data in a few hours on a medium equipped pc

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: Gullanian
Date Posted: 24 November 2003 at 7:03am

Phew. 1,000,000 records at 8 bytes each only comes to 8meg anyway

Thanks