PDA

Click to See Complete Forum and Search --> : Better multitasking during long db operations?


Sep 17th, 2000, 05:03 PM
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.

Sep 17th, 2000, 10:04 PM
Have you tried adding a "DoEvents" at the very bottom of your loop?

Sep 17th, 2000, 11:16 PM
Thanks! I think that's exactly what I needed. I wasn't even sure what direction to start looking.

Sep 17th, 2000, 11:54 PM
Glad to help