Maximum size of SQLQuery with revDataFromQuery ?

Tom Glod tom at makeshyft.com
Mon Aug 7 13:48:24 EDT 2017


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
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



More information about the Use-livecode mailing list