> You gonna let us in on the secret, or do we have to pony up for your master > class :)?
The discussion is a bit complex, and is built on a lecture in the class about how a real database server's internal objects and engines work, and how most of these don't exist at all in the QoQ mechanism. Basically, we show how ultra-inefficient QoQ is with every resource from memory to CPU to disk activity. You can't blame Macromedia for this; no other company could solve this problem, either. It's actually a necessity for QoQ to work the way it does, but it's still a nasty one. > BTW, Ben Forta just blogged about Blackstone QueryNew() and QoQs supporting > typed columns so it looks like that problem is going away. Yeah, I've been waiting for that one (you can't reliably UNION query objects until we get that feature), but it doesn't effect this issue. Respectfully, Adam Phillip Churvis Member of Team Macromedia http://www.ProductivityEnhancement.com Download Plum and other cool development tools, and get advanced intensive Master-level training: * C# & ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
