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