[Info-vax] Looking for some text search ideas
David Froble
davef at tsoft-inc.com
Sat Sep 27 19:08:07 EDT 2014
Jan-Erik Soderholm wrote:
> Paul Sture wrote 2014-09-27 13:01:
>> On 2014-09-27, David Froble <davef at tsoft-inc.com> wrote:
>>> Craig A. Berry wrote:
>>
>>>> A good regular expression engine would run circles around INSTR in both
>>>> functionality and performance. A full text search engine would too, and
>>>> if the data are simple, you could build your own with only moderate
>>>> trouble that indexed words (or characters if you wish) and saved either
>>>> unique key values or RFAs to get from the search string back to the
>>>> containing record(s).
>>>>
>>> Not RMS, but similar. The product file is just records with 50-60 data
>>> fields...
>
>
> Was it ever mentioned how many records/products we are
> talkning about here? A couple of thousands or millions?
>
>
A static allotment of a million nodes worked for all but one customer.
That one customer has about 2.5 million product records. I'm betting
their product file could use some clean-up, but that type of activity
doesn't sell parts. Don't count on it happening. Just sell them more
memory.
More information about the Info-vax
mailing list