Re: Duplicate Databases

In article 1pb345INNjko@emory.mathcs.emory.edu, rridley@sin-pss.DHL.COM (Richard Ridley) writes: > >Joe Hartley writes: > >>We've got a Sun 4/470 running SunOS 4.1.3 and an >>accounting/manufacturing/ order admin application that uses >>Informix/SE as its underlying RDBMS. The app requires SE; On-line >>is out of the question. > >Excuse the question, but why would an application 'require' SE ? >....Just interested to know :).... Well, near as I figure, the app doesn't actually use SE, but C-ISAM. So while the app doesn't actually use SE, SE is the only tool that will allow us to access the DB. That's approximatelt the message I got from the developer when I asked about compatibility with On-line. > >In the previous paragraph you state that the reports are CPU and I/O >intensive, whereas now it appears to be record locking - is it >necessary for the reports to be locking data ? Could you not use >'dirty reads'? Actually, the problem involves all 3 items. In a perfect world, we'd be able to rewrite the offending reports so that they behaved better and didn't pull the system down, but the world isn't perfect. >I would say that you would have to balance 'accuracy of data in >reports' against 'performance of machine' - if you had another >machine that you could put a 'snapshot' copy of the database on, and >use that to run reports on, then that would probably help, but that's >not exactly 'real-time reporting', is it :) ? The real-time aspects of this aren't critical; a 30 minute delay would be acceptable, but the problem I run into is that if I simply copy the files in DB1.dbs to DB2.dbs, I run into a problem with the order detail table (for example) being changed as I copy it! The solution I'm looking at now is a periodic copy of only those tables essential for reporting. We'll see how it goes. --- =============================================================================== Joe Hartley | jh@cadre.com - Whenever you find that you are on the Cadre Technologies | side of the majority, it is time to reform. - M. Twain 222 Richmond St. | -------------------------------------------------------- Providence, RI 02903 | Overman 1st Class - the Kilgore Trout Memorial Clench (401) 351-5950 x266 | of the Church of the SubGenius ===============================================================================