Hello Glenn, As far as text searches are the question, my experience is that REGULAR EXPRESSIONS on plain text (or huge string) are unsurpassed by means of speed and flexibility. I have developed quite useful crossword solving tool not using database to store words, querying it only with regular expressions and all the data loaded into single huge string. Check performance http://tripper-it.biz/crossword if you like. Excellent free TRegExpr component is available at http://regexpstudio.com/
Monday, June 13, 2005, 7:49:06 PM, you wrote: > > 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 the Yahoo! Terms of Service. -- Best regards, Toni mailto:[EMAIL PROTECTED] (Have you already tried my software http://tripper-it.biz ) ----------------------------------------------------- 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/
