Ted, PHDbase went much further than straight text searches as you could match words within say 3 words of your target as well as many other options such as totally fuzzy matching. I used it successfully in a job recruitment piece of software to analyse CV's from prospective job seekers and it was blazingly fast even on Pentium II's which were new technology at the time and when I first contacted Jim. Funnily enough this thread lead me to search for Jim again and I discovered my post in FoxWikki where I remember I got Jim's email address....
http://fox.wikis.com/wc.dll?Wiki~JimKorenthal As per Steven Black my email was/is being returned... Dave Dave Crozier Software Development Manager Flexipol Packaging Ltd. -----Original Message----- From: ProFox <[email protected]> On Behalf Of Ted Roche Sent: 01 August 2018 16:36 To: [email protected] Subject: Re: Optimised search of memo data. Does the quantity of text or the number of records or searches justify all the additional code and processes? VFP is wickedly fast at text manipulation and searching. searching for "Rabbit" in the full text (available from Project Gutenberg) returns 101 records out of 101 in 0.03 seconds on an old and small machine. CREATE DATABASE textsearch CREATE TABLE textsearch (iKey int autoinc, mText M, tUpdated T DEFAULT DATETIME()) FOR I=1 TO 101 INSERT INTO textsearch (mText) VALUES (textfile) NEXT SELECT * FROM textsearch WHERE "Rabbit" $ mText * returned 101 records in 0.03 seconds from a 15 Mb fpt FOR I=1 TO 1000 INSERT INTO textsearch (mText) VALUES (textfile) NEXT SELECT * FROM textsearch WHERE "Rabbit" $ mText * returned 1101 records in 0.33 seconds from a 150 Mb FPT * quit VFP and restart for cache clearing: 0.63 seconds On Wed, Aug 1, 2018 at 11:05 AM, Alan Bourke <[email protected]> wrote: > I was considering a simple MSSQL table with an nvharchar(max) field to hold the VFP memo contents, and full-text indexing on it. Then it is just a question of querying that from VFP, and refreshing the records in it from VFP on some sort of timed basis. > > -- > Alan Bourke > alanpbourke (at) fastmail (dot) fm > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/mm1p123mb095354d1ae19f7280c8c14e3fb...@mm1p123mb0953.gbrp123.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
