Last time I tried the Interbase and the MySQL as well via ODBC. Tried to insert with no keys, and the wanted define keys later on. What I saw was that the first 50.000 records went OK, but then everything slowed down, and became slower and slower until it was useless. The apllication ran for 3 days, and wasn't finished.
The data is a directory structure and the amounty of diskspace it fills. Lines like: 987000 /usr/kmi/test/this/that/and/so/on I want to store the whole kline and the number, and then perhaps create a transaction table holding the individual directories. What I want to do is: sort entries according to size, showing top level, and then breakdown by clicking. select entries like all entries containing /kmi/ Could be done by running through the textfile, but that is possible going to be to slow. So update a database during nighttime, and then have all the fun the next day. /Kaj -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Vahan Yoghoudjian Sent: 13. juni 2005 16:25 To: [email protected] Subject: RE: [delphi-en] Large database and efficiency? If you've just started to design your software... drop BDE... use firebird instead... what kind of data you will be inserting into the table? with the ideal design and distribution of data and creation of indices on the right fields you will get the performance you are needing. Vahan -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of kmikkels2003 Sent: Monday, June 13, 2005 3:01 PM To: [email protected] Subject: [delphi-en] Large database and efficiency? Hi I have 1.500.000 line of text that I need to search and sort interactively. I was thinking of putting them in a database, but I have had severe performace issues before when I try to enter large numbers of records via the BDE. I am usig D7. Any thoughts? /Kaj ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] -------------------------------------------------------------------------- -- ---- Yahoo! Groups Links a.. To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] ---------------------------------------------------------------------------- -- Yahoo! Groups Links a.. To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
