Find vs. Offset

[Peter Haworth]

Good suggestion Mark.  I'll jump in here.

When you call revOpenDatabase, specify the path name as ":memory:".  That
creates a database in memory instead of on disk which will disappear when
you close your application.  It does mean you'll have to create the
tables/columns each time you open the database but I think the only table
you would need would be the full text search table, no need to have
anything else in there.  You'd have to load the table too of course but
unless you have multi millions of rows, that would be very quick.

If you want to explore this further, I'd be happy to help with how to
create a full text search table and how to search it and interpret the
results.  The speed of retrieval with those things is pretty phenomenal and
the amount of code to get a,list of occurrences of a particular phrase is
limited to one SELECT statement.

Pete
lcSQL Software <http://www.lcsql.com>



On Wed, Dec 19, 2012 at 5:22 PM, Peter Bogdanoff <bogdanoff at me.com> wrote:

> Mark, that's new to me. Can you explain further?
>
> On Dec 19, 2012, at 5:15 PM, Mark Wieder wrote:
>
> > Peter-
> >
> > Wednesday, December 19, 2012, 4:03:43 PM, you wrote:
> >
> >> Thanks, Peter, that's what I was looking for.
> >
> >> Also, thanks Pete for the advice on using a database. That's what
> >> I used in a past, non-Livecode project, but unless the database can
> >> be embedded in the main stack, I can't use that here.
> >
> > Why not just use an in-memory database? Use a db name of ":memory:"...
> >
> > --
> > -Mark Wieder
> > mwieder at ahsoftware.net
> >
> >
> > _______________________________________________
> > 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
>