revDataFromQuery : size limit of mySQL query ?

[Peter Haworth]

I haven't come across a limit and I've certainly created some very large
SELECT results but I guess there must be one at some point.
If you run into one, you can probably get round it by using
revQueryDatabase to create a cursor although that would probably mean
rewriting a lot of your code.

One other unrelated suggestion.  I don't know if it's any more/less
efficient but you might try NOT IN ('John','Ted",...) in your SELECT
statement

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>


On Fri, Jun 6, 2014 at 12:52 PM, <jbv at souslelogo.com> wrote:

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