Results 1 to 9 of 9

Thread: [re-Resolved] Access not using enough CPU?

Threaded View

  1. #1

    Thread Starter
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Resolved [re-Resolved] Access not using enough CPU?

    Hi,

    I'm processing large text files and dumping them into tables (1.7gb of files spread over around 10-20 files).

    I would expect Access to eat most of the CPU power.

    It doesn't. It seems to peak at 35% (via task manager) then drop back to 0.

    I am using API calls to open and read the text file (as this was a hell of a lot faster than using Access functions/methods or VBA open file commands).

    Would there be some setting on Xp to slow it down?
    Or is this something Access usually does?
    Has anyone come across this before?

    I would prefer a higher cpu usage as that would mean (I hope) that the files would be process faster.

    Comments please
    Last edited by Ecniv; May 25th, 2005 at 06:07 AM. Reason: Access is not using enough and its wasted a day...

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

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