Find vs. Offset

Peter Haworth pete at lcsql.com
Tue Dec 18 16:56:30 EST 2012


Hi Peter,
You might consider taking a look at the SQLite Full Text Search table
functionality.  It's easy to set up, harder to learn hot to retrieve stuff
correctly.  But it is lightning fast.
Pete
lcSQL Software <http://www.lcsql.com>



On Tue, Dec 18, 2012 at 1:13 PM, Peter Bogdanoff <bogdanoff at me.com> wrote:

> Colin,
>
> Thanks. It is a reference work. However I'm allowing a string search which
> could be several words or parts of words. But I suppose an index could
> handle that.
>
> Peter
>
> On Dec 18, 2012, at 7:03 AM, Colin Holgate wrote:
>
> > If it's a reference book you could pre index all of the words, then have
> a find field that knows the list of words used in each page. You could
> quickly know which cards contain any given word (using offset), and could
> then go to those cards to do a local find, to highlight the word.
> > _______________________________________________
> > use-livecode mailing list
> > use-livecode at lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



More information about the use-livecode mailing list