Dear mailing list. My current application make use of partitioning by creating a new child table which holds transaction records for every month. I've notice that after a couple of months depending on the hardware at some of our clients the inserts become very slow. The reason memory. I don't want to delete old child tables even though they may be queried seldom and we can't upgrade memory since most clients are far and remote. I'm in the design faze of a new GUI and DB layout, what are my options.
Create a DB for each month. Create a Schema for each month. Example Schema layout Public.schema (will have all tables and the current months transaction table) Jan2012.schema (This will just have the archive transaction table for Jan 2012) Feb2012.schema Mrt2012.schema I've red a couple of articles regarding data warehousing but they don't mention schema's to split large transaction tables. Will multiple schema's solve my problem ? Regards Bartel Viljoen [cid:ncc-line7282.png] [cid:ncc-sig251f.png]<http://www.ncc.co.za> Network & Computing Consultants (Pty) Ltd E-mail : bar...@ncc.co.za Phone : 086 155 5444 Fax : 051 448 1214 Url : www.ncc.co.za<http://www.ncc.co.za> [cid:ncc-line1d18.png] E-mail Disclaimer<http://www.ncc.co.za/legal/email-disclaimer.html> Disclaimer added by CodeTwo Exchange Rules 2007 www.codetwo.com<http://www.codetwo.com>
<<inline: ncc-line7282.png>>
<<inline: ncc-sig251f.png>>
<<inline: ncc-line1d18.png>>
