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
> wrote:
>
> Query return
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 d
i can't say for surebut 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 ramor you don't hit some OS
limitlike the one i love so much in windows.
i've done some pretty large selec
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
se
