Also using the query functions which allow iteration over the result set will minimise data transfer at any one point in time (assuming it's a decent client driver).
Warmest Regards, Mark. Sent from my iPhone > On 7 Aug 2017, at 19:45, Bob Sneidar via use-livecode > <use-livecode@lists.runrev.com> wrote: > > Query return data is more of a performance issue. The whole point to SQL is > efficient data access, and a great deal of time is spend when teaching SQL on > designing databases around that concept. > > It's one thing if you have columns with large blobs, but if you are talking > about returning large datasets with lots of records, it may be a design > issue. You may want to consider creating some SQL functions that process the > data on the server itself instead of having LC do the processing. > > That being said, it is possible to "page" through the SQL data by using > OFFSET and LIMIT. Just keep track of the offset, set the limit to something > like 1000, and page your data in and store it as you see fit. > > Bob S > > >> On Aug 7, 2017, at 10:48 , Tom Glod via use-livecode >> <use-livecode@lists.runrev.com> wrote: >> >> i can't say for sure....but wouldn't the limit be the "size" of a variable >> in lc? ...and i think you can cram as much into your variable as you want >> as long as you have the available ram....or you don't hit some OS >> limit....like the one i love so much in windows. >> >> i've done some pretty large select all queries..... and i've never had a >> problem. >> >> On Sun, Aug 6, 2017 at 2:59 PM, jbv via use-livecode < >> use-livecode@lists.runrev.com> wrote: >> >>> Hello >>> Is there a size limit for the SQLQuery parameter when using >>> revDataFromQuery ? >>> I might end up with mySQL queries of at least 75 Kb... >>> I know the best way to know is to try, but any experience would be >>> apreciated... >>> >>> FYI some of there queries have been tested in PHPmyAdmin and run in 0.0054 >>> sec; >>> my concern was rather the buffer size between LC engine and mySQL... >>> >>> Thanks in advance. >>> jbv > > > _______________________________________________ > 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
