Find vs. Offset

[Peter Bogdanoff]

Pete,

I'm intrigued. Please contact me off the list.

Peter

On Dec 19, 2012, at 5:59 PM, Peter Haworth wrote:

> 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
>> 
> _______________________________________________
> 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