> 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.
If you are wanting to search for key words only, you should consider writing a simple text scanner to break your text into words and a database to contain the words along with a reference to the original text. However, if you are wanting to do ad hoc word or phrase searches, like you would do in a text editor, for example, a database will probably not provide any performance advantage over a simple text search. Check the FIND command line utility included with the OS for an example. It is quite easy to write code to do the equivalent of the FIND command. Try using the FIND command to do some searches on your text to get an idea about the performance. The thing to remember here is that to do an open phrase search of a database in SQL, you use the LIKE comparator which reverts to a table scan. Glenn Lawler ----------------------------------------------------- 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/
