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 <bogdan...@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 > > mwie...@ahsoftware.net > > > > > > _______________________________________________ > > use-livecode mailing list > > use-livecode@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
