bob blipped,
> Livecode currently can only send one statement per query to *any* sql server, > at least that is what I have come to understand. Trust me, I send a single transaction of several hundred SELECT every time I open a debtor “file”. Not being able to do updates as a block, though, could give me inconsistencies if I could have both failures and successes in the same set, to the point of having to pack my bags and go home. > But I do not think issuing many queries from livecode is the bottleneck, but > rather the ability of the SQL server to respond. I happened to have a notable latency at the time, which made things far worse. But when you have a great many, you have a built in 2n*latency lag, even if the transactions themselves took no time. _______________________________________________ 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
