Hi Robert, As I see it you have three choices:
1. Move old inactive records to an archive file. If you move enough, you should avoid the 2gb limit. Of course, the records you move will no longer be available to the normal programs and you may hit referential integrity problems - so this is probably not the best solution. 2. Convert the file to 64 bit. The underlying file system will need to support 64 bit files and the conversion process itself will take a lot of time. So this is probably not practical as well. 3. Use a distributed file. This involves moving a subset of your records to another file or files (called partfiles) and defining an algorithm which chooses which of the part files the record should belong to. The software wont need changing, the performance impact is minimal (providing that your mfiles setting is reasonable) and you should be able to do it in small chunks so downtime can be managed. This is probably your best bet.... cheers, asvin [email protected] wrote on 06/11/2009 22:32:37: > "Robert Porter" <[email protected]> > Sent by: [email protected] > > Nov 06 2009 22:32 > > > My patient file has a few months to it hits the limit, and have been > working on a solution... The problem is the records are updated > frequently. I tried to implement a trigger replicating the record to > a distributed file in our test side, and it impacts performance WAY > too much (upwards of 5 seconds before the sub even starts to > execute). The copy alone I'm estimating to take close to 3 days > based on the some test runs. I can't knock out 1/2 a dozen hospital > labs and a couple dozen clinics for 3 days... so I'm not sure how to > handle it just yet. I'm open to suggestions... > ************************************************************ HSBC Bank plc may be solicited in the course of its placement efforts for a new issue, by investment clients of the firm for whom the Bank as a firm already provides other services. It may equally decide to allocate to its own proprietary book or with an associate of HSBC Group. This represents a potential conflict of interest. HSBC Bank plc has internal arrangements designed to ensure that the firm would give unbiased and full advice to the corporate finance client about the valuation and pricing of the offering as well as internal systems, controls and procedures to identify and manage conflicts of interest. HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ, United Kingdom Registered in England - Number 14259 Authorised and regulated by the Financial Services Authority. ************************************************************ ----------------------------------------- SAVE PAPER - THINK BEFORE YOU PRINT! This transmission has been issued by a member of the HSBC Group "HSBC" for the information of the addressee only and should not be reproduced and/or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
