Results 1 to 4 of 4

Thread: Better multitasking during long db operations?

  1. #1
    Guest
    I'm currently working on a project in VB6, using DAO, that requires me to check an xbase db for 3600+ items to see if they are in stock, before generating an entry for it on a web page. Whenever the program is in the loop performing this operation, it practically renders the system unusable. The operations usually take ~45 minutes on a P3-500 system.

    What I would like to do is add some code to it that will allow the program to handle running in the background better (at all). Can anyone suggest something? Any help would be appreciated.

  2. #2
    Guest
    Have you tried adding a "DoEvents" at the very bottom of your loop?

  3. #3
    Guest
    Thanks! I think that's exactly what I needed. I wasn't even sure what direction to start looking.

  4. #4
    Guest
    Glad to help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width