If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Brilliant Database > Import speed

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Sep 2011
Location: Australia
Posts: 215
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.
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
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?
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Jul 2011
Posts: 130
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On