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