On Fri, Jul 16, 2010 at 1:30 PM, Jarvis, Matthew <[email protected]> wrote:
> So it's just this one table you have to worry about right now? > > Stephen brings up a good point.... If the client wants to add a bunch > more records, and you aren't inclined to bite the bullet and convert to > another storage arrangement, then trimming columns in the table might > buy you some more time. Calculate max lengths in your text fields and > trim accordingly. Those bytes might really add up.... ------------------------ Having a description column in char(50) and all you need is 31 as your max() length today in a table that is 1.5 mill rows could save you a lot of space bringing it down to only char(35) today. Just removing itemDescription out of the same table will give you a lot more TIME in the near future as well. Granted your reports are going to need a tweak but you know that whatever you decide you have a big job ahead. Just UNION the SQL to go against both tables for data for cust#ABC123. Could you take data out of this table for transactions prior to date()- 365 * 5 ? Just leave data 5 years or newer in the current table. Maybe you are down to only last 18 months as it is, and if so could you separate the transactional data int a pair of tables for customers whose first char() # or A-L, and second table M-Z? Still a PITA to screw with but just a different idea on busting up data to usable sized tables. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** 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.
