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 _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
