There is only 1 program that updates the source file, I was going to add an execute to the end of it, to build the index when it's done. No programs access the source file during the course of a normal day, so if an exclusive lock gets created on it, it won't hold any other processes up.
In this case, it would be fine. Also considering the phantom that runs the program runs at 5:00am and no one is on the system anyway. I was concerned that having the index on the other file (which trans to the source file) would slow down the program that updates the source file, but since it doesn't that's even better. George > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Bob Woodward > Sent: Tuesday, November 09, 2010 4:32 PM > To: U2 Users List > Subject: Re: [U2] Index based on an I desc of TRANS data > > With a 3 minute build time of the index, you might be able to do a > timed > process, like every 6 hours, to keep it "fairly" current. > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
