Maximum length of mySQL request ?

[Bob Sneidar]

I googled around a bit and there doesn't seem to be a limit on statement length. I will say though that the nature of the query indicates a possible design issue with the database. I suspect however that you are at the mercy of someone else's schema. That there is no common denominator you can query on is to me remarkable. How are you obtaining your IDs then? 

Bob S


> On May 20, 2022, at 03:34 , jbv via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> Hi list,
> 
> Is there a maximum length limit for mySQL requests ?
> I don't mean the results returned by mySQL, but the request itself.
> 
> For instance, I have a table with 180000 entries and counting, and
> I will need to send requests such as :
> SELECT FROM myTable WHERE id = 5523 OR id = 7831 OR id = 162814 OR id = 34895...
> and at times the request might concern 100 ids or even more.
> 
> I am not too concerned about execution speed, as id is a unique key,
> but rather for the request itself : I wonder if it might be truncated
> if too long...
> Or perhaps a better and safer practice would be to break it into a serie of
> shorter successive requests when it exceeds a certain threshold ?
> 
> Thank you 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