With sqlite on my box, doing the inserts via a transction took the time down to 36 seconds from 64, still not good enough.
On Tue, Feb 10, 2015 at 11:58 AM, Mike Bonner <bonnm...@gmail.com> wrote: > You can find an example that uses begin transaction, and commit with a > repeat loop here: > http://forums.livecode.com/viewtopic.php?f=7&t=14145&hilit=+transaction > > On Tue, Feb 10, 2015 at 9:20 AM, Mike Kerner <mikeker...@roadrunner.com> > wrote: > > > Mike B, no, I wasn't, proving once again that I don't know everything. > > Could you come over here, I need to do a mind meld. I'll mess with that > in > > a minute. I was also going to see if mySQL was any different, but I > > haven't done it, yet. > > > > > > On Tue, Feb 10, 2015 at 10:28 AM, Ali Lloyd <a...@runrev.com> wrote: > > > > > > Which v7 build is that? Is it one we have or one coming up? > > > > > > I've just submitted the pull request so once it's reviewed it will be > > > merged and appear in the next build, so hopefully 7.0.2 RC 3. > > > > > > > Does LC 7 now do character references in constant (albeit a bit > slower) > > > time? Or linear? Or... > > > > > > In theory it should, yes. When you get char x of a native string, as > long > > > as the engine remembers that it is native, (which was fixed for a few > > > missing cases in bug 14504), it will act as if you used the codeunit > > chunk > > > instead, with the corresponding benefit of constant-time access. Indeed > > > this should also work for strings that the engine is storing as utf-16 > > > which contain no combining characters or surrogate pairs. > > > > > > On 10 February 2015 at 15:11, Mike Bonner <bonnm...@gmail.com> wrote: > > > > > > > Thanks Ali! > > > > > > > > On Tue, Feb 10, 2015 at 8:10 AM, Mike Bonner <bonnm...@gmail.com> > > wrote: > > > > > > > > > Mike K, are you wrapping the inserts in a begin/commit block? It > > > makes a > > > > > HUGE difference in speed. (otherwise, each is a separate > transaction > > > with > > > > > all the overhead. If wrapped, its a single transaction, and so > much > > > > > faster. > > > > > > > > > > On Tue, Feb 10, 2015 at 7:36 AM, Geoff Canyon <gcan...@gmail.com> > > > wrote: > > > > > > > > > >> Yay, that's great news. Does LC 7 now do character references in > > > > constant > > > > >> (albeit a bit slower) time? Or linear? Or... > > > > >> > > > > >> On Tue, Feb 10, 2015 at 4:50 AM, Ali Lloyd <a...@runrev.com> > wrote: > > > > >> > > > > >> > Apologies - hit send too early. > > > > >> > > > > > >> > > > > > >> > 6.7.1 > > > > >> > > > > > >> > There are 2931 lines in tstart > > > > >> > > > > > >> > There are now 14655 lines in tstart > > > > >> > > > > > >> > revers(ta) took 427 ms > > > > >> > > > > > >> > qrevers(ta) took 6 ms > > > > >> > > > > > >> > Output OK > > > > >> > > > > > >> > krevers(ta) took 412 ms > > > > >> > > > > > >> > Output OK > > > > >> > > > > > >> > > > > > >> > 7.0.2 + bugfix > > > > >> > > > > > >> > There are 2931 lines in tstart > > > > >> > > > > > >> > There are now 14655 lines in tstart > > > > >> > > > > > >> > revers(ta) took 142 ms > > > > >> > > > > > >> > qrevers(ta) took 32 ms > > > > >> > > > > > >> > Output OK > > > > >> > > > > > >> > krevers(ta) took 258 ms > > > > >> > > > > > >> > Output OK > > > > >> > > > > > >> > On 10 February 2015 at 04:10, Kay C Lan < > lan.kc.macm...@gmail.com > > > > > > > >> wrote: > > > > >> > > > > > >> > > On Tue, Feb 10, 2015 at 11:58 AM, Geoff Canyon < > > gcan...@gmail.com > > > > > > > > >> > wrote: > > > > >> > > > > > > >> > > > It seems that what we've lost with unicode/7 is the speed of > > > > >> character > > > > >> > > > references. > > > > >> > > > > > > > >> > > > > > > >> > > See Ali Lloyd's earlier response that the LC team have been > > > watching > > > > >> this > > > > >> > > tread and it's clear that 'inefficient code' has been > revealed. > > > The > > > > LC > > > > >> > team > > > > >> > > are working on it and believe that for none Unicode chunking > LC > > 7 > > > > >> should > > > > >> > be > > > > >> > > as fast as LC 6. There will be some slow down when Unicode is > > > > >> involved. > > > > >> > > _______________________________________________ > > > > >> > > 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 > > > > > > > _______________________________________________ > > > 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 > > > > > > > > > > > -- > > On the first day, God created the heavens and the Earth > > On the second day, God created the oceans. > > On the third day, God put the animals on hold for a few hours, > > and did a little diving. > > And God said, "This is good." > > _______________________________________________ > > 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 > -- On the first day, God created the heavens and the Earth On the second day, God created the oceans. On the third day, God put the animals on hold for a few hours, and did a little diving. And God said, "This is good." _______________________________________________ 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
