I've never gotten too intimate with Flashboards, but isn't there a history form (FB:History) that stores the computed/calculated values for graphing? Maybe that could be cleaned up as well.
Thad Esser On Thu, Dec 23, 2010 at 7:25 AM, Frank Caruso <[email protected]>wrote: > ** ARS 6.3 > Oracle 10 > > Deleted 3.3 million records from the SHR:ConsolidatedList form. There are > now only 15,000 records but the queries the MidTier runs for flash boards > are still slow - upwards of 20 seconds. The queries are counting groups of > records by category and group. There are no where clauses so I would not > think it is an index issue. I also made sure that statistics has been run. > The deletes were done using an ARS Perl script. > > Any thoughts on what else I might look at? > > Frank Caruso > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
