Results 1 to 3 of 3

Thread: Import speed

  1. #1
    Join Date
    Sep 2011
    Location
    Australia
    Posts
    218

    Import speed

    I assume members have found that importing large text files (CSV etc) in to a database is extremely slow (hours for 10,000+ records).
    As a test tried first importing 10,000 records in to access table (using MS Access 2000) then import from mdb to BB database - the difference is amazing -from hours to seconds. It appears the text parser/import is a weak link not some hidden indexing as I thought might be slowing things down. Checked with a find on these 10,000 records and response ok at a few seconds - a query gives an instant result.
    Just a warning, managed to corrupt a dummy database on first attempt. Suspect mismatch field types may have been cause.
    Anyone know of freeware program that can open mdb files and import txt data, at least until Binary Brilliant can fix this problem - not in V10 by first tests?
    Update.
    Excel xls files appear ok as well - will try some free spreadsheet programs.
    Last edited by tamcind; 01-06-13 at 06:37.

  2. #2
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    487
    Suggest you do some more analysis . . .

    We do not have BD, but delimited files load very quickly into several other pc and mainframe databases. . .

    Is the data already on the BD box? Might the lost time be due to transimssion issues?

  3. #3
    Join Date
    Jul 2011
    Posts
    132
    Sometimes stability(root damage, time out) and slowness is the drawbacks in the BD. I hope with the new version this will be solved by the time they release.

Posting Permissions

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