very good thanks for elaborating Bob.......it makes sense that there are use cases where the library really kicks it...... esp since its an in memory database (assuming). Its a good idea, making me rethink a couple of things.
On Fri, Jun 21, 2019 at 12:06 PM Alex Tweedly via use-livecode < use-livecode@lists.runrev.com> wrote: > Hi Bob, > > It sounds like your library is something I could benefit from :-) > > I know it's been mentioned on the list before, but I've lost track of > where to get it from, and a quick search didn't turn anything up. Could > you please send a reminder (either to the list or direct to me if you > prefer). > > Thanks > > Alex. > > On 21/06/2019 16:02, Bob Sneidar via use-livecode wrote: > > Hi Tom. > > > > So the little benchmarking I did originally showed that my method was a > little longer, as I still have to iterate once through the array to > populate the database. Where it really shines is that you can do complex > queries, as well as multiple column sorts before converting back to an > array. Also, if you need to make multiple passes at the data, the speed of > course exceeds iterating through the array again and again. Finally, since > it's in a database, it's persistent through idle, whereas an array would > have to be stored in a script local or a property if you needed it across > runtime sessions. > > > > Bob S > > > > > >> On Jun 20, 2019, at 21:10 , Tom Glod via use-livecode < > use-livecode@lists.runrev.com> wrote: > >> > >> A great question Jacque ....Helpful thread all around. > >> > >> I have a tendency to think that any operation i perform to convert an > >> entire array into something else will take longer than to loop through > the > >> keys. I'm happy to be wrong ,and I imagine it depends on the number of > >> items in the dataset. But for my particular use at the moment, I find LC > >> performance to be excellent. > >> > >> Bob I'm interested in your library......mostly learning the point at > which > >> it makes sense to do that conversion and what kind of speedups can > >> occur.....have you done any benchmarks on it? > >> > >> Great reminder & idea Monte > > > > _______________________________________________ > > 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