Typo, should be ":memory:". On Sat Feb 14 2015 at 2:01:45 PM Mike Kerner <mikeker...@roadrunner.com> wrote:
> Pete, is that a typo, or did you mean to have a semicolon instead of a > colon in front of "memory"? Does ";memory:" work, too, or just ":memory:"? > > AND HOLY CRAP, yes, Pete, you're right, you were doing 100k records, where > the other example was only doing 10k. So doing 100k records with REPEAT > WITH took > wait for it > wait for it > Believe me, I was waiting, and waiting, and wating for it > FIFTY EIGHT MINUTES AND THIRTEEN SECONDS. > > REPEAT FOR is .129 seconds, and REPEAT WITH is TWENTY SEVEN THOUSAND TIMES > SLOWER (for this operation)??!?!?!?!?!??? > > Hey, Pete, "That's a common technique"...WHAT? If it's so common, and all > of this is common knowledge, then how come it isn't documented, anywhere, > and how come this is the first time I remember EVER hearing about this > difference? What else don't I know about??? Grrrrrrrrrrrrrr. You would > think that Edinburgh would think about tweaking an algorithm, since REPEAT > WITH seems to be a special case of REPEAT FOR, and you can generate the > REPEAT WITH behavior by wrapping the REPEAT FOR... > > On Fri, Feb 13, 2015 at 6:56 PM, Bob Sneidar <bobsnei...@iotecdigital.com> > wrote: > > > Oh thanks. That would have screwed me up if I had tried to use “memory”. > > > > Bob S > > > > > > On Feb 13, 2015, at 15:34 , Peter Haworth <p...@lcsql.com<mailto: > > p...@lcsql.com>> wrote: > > > > We both used in memory databases. The filename is ";memory:" > > > > _______________________________________________ > > 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
