I'm trying this now, thanks.
Larry Hiscock wrote: > > Are any of your indices based on virtual fields? I haven't worked with UV > in a while, but UD has the DISABLE.INDEX, ENABLE.INDEX and UPDATE.INDEX > commands. If UV also has them, you could disable the indexes prior to the > archival and re-enable and update them at the end. I'm not sure if it > would > be any faster, but certainly worth an attempt. > > Larry Hiscock > Western Computer Services > > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ryan M > Sent: Thursday, September 09, 2010 10:07 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] Slow READ/WRITE with indexes > > > I am hoping I can find some help here. I am running into a serious > performance issue with indexes on our UV system (UV 10.2, on AIX). > > An example of this is our sales order files, SO (current/active) and SOH > (history) files. We archive sales orders from SO to SOH on a daily basis, > this is moving approx 15,000 records from one file to the other. If I > remove all indexes from both files, the process flies by, hundreds of > transactions per second. But, with indexes on, we are luck to get one per > second. > > Basically what happens with the code that does the archiving is it reads > the > SO record, does some quick checks to make sure we can move it, then writes > the record to SOH, then deletes the SO. > > There are 7 indexes on the SO file and 5 on the SOH. > > I've tried removing one index from a file and running the process, but see > no performance gain until all indexes are gone. > The SO file is approx 7GB with 280k records, and the SOH file is 11GB, > with > 8,900,000 records > > I have check the files sizes in UV and they are correct. > > Can anyone provide some pointers on ways to setup indexes so they will run > faster? Some of the indexes are 'ORDER.DATE', 'COUNTRY', 'MEMBER ID' > -- > View this message in context: > http://old.nabble.com/Slow-READ-WRITE-with-indexes-tp29653705p29653705.html > Sent from the U2 - Users mailing list archive at Nabble.com. > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > -- View this message in context: http://old.nabble.com/Slow-READ-WRITE-with-indexes-tp29653705p29670902.html Sent from the U2 - Users mailing list archive at Nabble.com. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users