Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - Access
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Access

 Post Reply Post Reply
Author
Gullanian View Drop Down
Senior Member
Senior Member
Avatar

Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373
Post Options Post Options   Thanks (0) Thanks(0)   Quote Gullanian Quote  Post ReplyReply Direct Link To This Post Topic: Access
    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?



Edited by Gullanian
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4671
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post 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 :)
Back to Top
Gullanian View Drop Down
Senior Member
Senior Member
Avatar

Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373
Post Options Post Options   Thanks (0) Thanks(0)   Quote Gullanian Quote  Post ReplyReply Direct Link To This Post 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?
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4671
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Gullanian View Drop Down
Senior Member
Senior Member
Avatar

Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373
Post Options Post Options   Thanks (0) Thanks(0)   Quote Gullanian Quote  Post ReplyReply Direct Link To This Post Posted: 24 November 2003 at 7:03am

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

 

Thanks

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.07
Copyright ©2001-2024 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2024 Web Wiz Ltd. All rights reserved.