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 <*> 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/
