The data needs to be stored some way, becaus I want to create an application the the users themselves can search, sort and so on, to decide what can be deleted. I thought I wasn't able to store all data in the memory at once, so I needed to save it in prtions anyway, and thats why I thought about the database approach, because of the possibilities of searchin and sorting.
But as Walter earlier stated, I may be able to store evrything in memory, and that would be faster anyway. Thanks for your thoughts. anyway. /Kaj -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: 14. juni 2005 07:46 To: [email protected] Subject: Antwort: [delphi-en] Large database and efficiency? Hi Kaj, well I would like to drop some thoughts into this discussion. The question arose : why store the data in a database and not doing the sort/search on-the-fly with the actual data. The way a database works differs in some points from the way a program may find some information withiin some collected data: the 'result' of the sort is stored in an easy-to-retrieve way: this are the Keys of a table. A single Item is easily inserted or deleted from the data.collection without the need of re-sorting the whole bunch. Because sorting-algorithms are widely available (as databases are) the amount of coding could be the same for both approaches. So we can make checkboxes to get an answer: Does the data-collection of directories/filenames change frequently Is the sort ALWAYS based on the same data-item is it a one-and-only result you want to retrieve If it looks like a database problem, you have to choose which database. Someone pointed out NOT to use the BDE which REALLY is a good hint! I would suggest you to use a SQL- Client-Server Database which could run as a desktop-DB as well, this would give you the most amount of flexibility. (Firebird or Interbase would be a good choice, I agree. The latter is more expensive). As for the performance issues, there are some articles describing the Does and Dont's if you like to speed up your db-engine and you could have probably stepped into one of them with your first try. So it's up to you now! Happy coding Bob > 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 <*> 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/
