sqlYoga queries
Bob Sneidar
bobsneidar at iotecdigital.com
Tue Jul 26 11:06:59 EDT 2022
Hi. This is directed at Trevor Devore, although if anyone else knows they can chime in.
sqlYoga can define table objects and relations in a database object. Heretofore I have not availed myself of this, being content to only work with query objects and record objects. Now as I am trying to optimize this new socket agent I wrote, I am wondering if a single query for all the data for a given customer/site/device would be more time efficient than multiple queries for each table. So the question is, if I were to use table and relations, could I craft a statement so that it perfoms a single query?
Bob S
More information about the use-livecode
mailing list