I recently ran into a similar issue. I have a record set that was cached with 45,000 records. The performance on the QoQ against this cached query was not to my liking. If was directly displaying the cached query and not performing a filter, it works great. If you want to take a subset of this data, I suggest not having the cached query. I converted into a stored procedure, so that DB performed the execution plan and perform the filters a lot more quickly.
The only times that I have trouble with data sets is when I run into an ODBC data set that I do not have access to and have to use CF to process through the returned results of the filter. On 3/16/07, Rick Root <[EMAIL PROTECTED]> wrote: > > On 3/16/07, Robertson-Ravo, Neil (RX) < > [EMAIL PROTECTED]> > wrote: > > > > So, it was a select * into app scope? > > > Well.. not TOTALLY... certain "codes" in the table have multiple values.. > but for the most part we don't care about the multiple values... so I only > used the first value... > > table id (code type), table key (code), code value > > Our mainframe application stores *ALL* of its codes in this single code > table. > > You can see an example of the data at www.it.dev.duke.edu/tools/codebook > > I built a flex app for looking up codes =) > > All over the web site, I have dropdown lists populated by these codes... > they used to be based off a query of queries, and the base query was > stored > in the application scope... now they just query the db directly. > > Rick > > -- > > CFMBB - Coldfusion Message Boards, Version 1.21 Now Available! > > http://www.cfmbb.org > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272838 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
