Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2004
    Location
    St Petersburg, FL
    Posts
    5

    Unanswered: Improving large file performance?

    I frequently run ad hoc analysis on large files from a number of sources. Large .mdb files don't seem to do too well from a performance standpoint. MSDE is also a little slow, as I often need to import a couple 100MBs of text files into the database for querying. Often the only way I can get information from some sources is large text extracts that I store on the local hard drive.

    Would it increase performance if I purchased a large flash card and used that to read/write to? ...or would it make more sense to invest in a faster hard drive? (Corporate policy doesn't let marketing analysts write to SQL servers).

    Thanks in advance,
    Brian

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    A quicker hard drive is the better bang for the buck. Is there any policy about installing a personal instance of MySQL or something better suited to that volume on your local computer?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Aug 2004
    Location
    St Petersburg, FL
    Posts
    5
    I'm not aware of any restrictions. Would MySQL offer superior performance to MSDE?

  4. #4
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    What kind of performance are you looking for? Does it take two minutes? Twenty minutes? Or longer to run your queries?

    There are alot of things that could be effecting your performance. How old is your computer? Is all of the data stored on your local system? Anything on a server? How much memory do you have? How much free hard drive space do you have? If you are linking to text files then you are not able to use indexing. When you import data have you set up appropriate keys?

    I use Access to report on large amounts of data and don't have too many problems. There are times when the file gets to be close to 1GB when performance gets flaky. But for the most part if the file size is 700MB or less it seems to perform well enough.

Posting Permissions

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