Maximum size of SQLQuery with revDataFromQuery ?

[Bob Sneidar]

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 at 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 at 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