Yes I always get the data into the subset required, grouped and sorted insofar as possible, before reporting. Especially with big datasets.
-- Alan Bourke alanpbourke (at) fastmail (dot) fm On Fri, 16 Jan 2015, at 09:39 PM, Stephen Russell wrote: > Had to touch the trial balance report and I cannot wipe the stain off my > fingers. > > My gl table in one of our companies maintains about 450 mill rows per > year > and the indexes I want I cannot add in for fear of potential disk loss. > We > have 7 years of gl data. > > I can select the raw rows in a Select * from Where t_yer = 2014 and get > them in just over 2 min. > > Or I Pre-Sum the bastards with a group by and only bring back 48 thousand > rows in 20 seconds. > > > > -- > Stephen Russell > Sr. Analyst > Ring Container Technology > Oakland TN > > 901.246-0159 cell > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1421445426.1842911.214945449.76076...@webmail.messagingengine.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
