Sure. _______________________________ Jeff Fleitz Tekquest, Ltd Integrated Digital Solutions http://www.tekquest.com _______________________________
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of Adam Churvis > Sent: Wednesday, December 01, 2004 4:55 PM > To: [email protected] > Subject: Re: [plum] Query Questions > > Jeff, > > We're not seeing any of what you're describing. Could you > send us the code in question? > > 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 > > ----- Original Message ----- > From: "Jeff Fleitz" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Wednesday, December 01, 2004 4:00 PM > Subject: [plum] Query Questions > > > > Hey Adam/David, > > > > I am building a list that I am using a custom query for > because I need a > > 3-level join, and which is referenced using the query > attribute of the > > DisplayList tag. > > > > I noticed that even though the list is correctly using the query I > specify, > > the 'default' query for the list runs as well even though > it is not being > > used, essentially doubling the execution time. > > > > 1. Can we eliminate the 'default' list query? I would like > to see this > > extra database hit eliminated when a custom query is > referenced in the > tag. > > 2. The default query is cached after the first hit, but the > custom query > is > > not. Is there a way to do this? If not I would also like > to see this > > implemented. > > 3. I would like to see a switch to exclude the > contentByCategory query, > > which seems to be run with each hit to the site. This is also a > performance > > killer. It makes sense to have it on the public side, but > most of the > > backend custom modules will not see it, so there is really > no need to > > include it. > > > > Jeff > > > > > > _______________________________ > > > > Jeff Fleitz > > Tekquest, Ltd > > Integrated Digital Solutions > > http://www.tekquest.com > > _______________________________ > > > > > > > > > ********************************************************************** > > 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 > > > ********************************************************************** > > > > > ********************************************************************** > 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 > ********************************************************************** > > ********************************************************************** 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 **********************************************************************
