On Wed, Mar 19, 2003 at 04:12:32PM +1100, Hickman, Matt wrote: > We recently archived 5million records in this table to csv file as the DBA > was freaking out about such a large table.
Since you've got a DBA I'd assume you're running a serious database, not something like Access. If that's the case, I don't understand the concern. > We noticed no performance issues on the user end and not sure how the server > was coping but we had no outages for ages either. In that situation I'd recommend making an archive file with the same specs as the original. Then ensure that queries to it hit appropriate indexes. Then periodically move the contents of the live log file to the archive. Your DBA should be able to setup import routines that drop the indexes for the bulk move, which would speed things up. Without knowing other factors, this sounds straight out of the MSCE school of database management. Wait a second, here's a thought. What's the record size? He might be running into system file size limitations. 100 characters * 5M records = .5G database 1000 characters * 5M records = 5G database All that's needed here is to switch to a database that can spread tables over multiple files, or move the server to a 64 bit platform :) Or, more practically, split the data up into yearly/quarterly archives. Paul Haddon Technical Services Manager Formstar Print Technologies --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
