revDataFromQuery : size limit of mySQL query ?

jbv at souslelogo.com jbv at souslelogo.com
Fri Jun 6 18:06:56 EDT 2014


Thanks fr the reply.
Actually I'm pretty confident about the results of the query, as I have
created very large results myself.
My concern was more with the query itself...

jbv

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