revDataFromQuery : size limit of mySQL query ?

jbv at souslelogo.com jbv at souslelogo.com
Fri Jun 6 15:52:23 EDT 2014


Hi list,

Does anyone know if there is a limit in the length of the sql query
when using revDataFromQuery ?
According to what I found on the web, there doesn't seem to be
any problem on mySQL side (default value is apparently 1 Mb),
but I was more concerned by a possible buffer between LC and
mySQL where the query could be truncated...

Furthermore, I am fully aware that very long queries are hard
to maintain and might lead to slow execution...
What I have in mind in some rather simpler stuff like :
SELECT name FROM myDB WHERE name != 'John' AND name != 'Ted'...
where the list of names can be quite long...

Thanks,
jbv





More information about the use-livecode mailing list