I didn't think so.... It's not worth the trigger route. The data isn't used on a daily basis, and when it used, it's not an issue to delete and rebuild the index. For the 3 minutes it takes to build the index, it will make life much easier when we are using that field to do manual searches.
A manual search without the index takes a little over a minute with the index, about 2 seconds > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Wols Lists > Sent: Tuesday, November 09, 2010 3:55 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Index based on an I desc of TRANS data > > On 09/11/10 20:47, George Gallen wrote: > > I just created an Index on a fairly large file based on an I Desc. > > > > The IDESC is combination of Concatenating 5 TRANS()'d fields. > > > > After the index was built, it works great....but just curious, Will > the > > index get updated automatically, when the source file's data changes? > > A GREAT BIG NO! > > > (remember, the index is based on TRANS'd data), Or > > will I need to periodically rebuild the index, which in itself > wouldn't be an > > issue as the source file doesn't change very often. > > The index will get updated every time the record changes, but it won't > know data in other files (the trans'd stuff) has changed. > > What you *might* be able to do, is every time a record in the source > file changes, have a trigger-type routine (maybe in an index itself :-) > that selects all the records in the target file that depend on that > record, and does a quickie "read and write". That will ensure that the > index will pick up all the records it should. What it will not do is > ensure that it doesn't pick up records it shouldn't - because although > the write will trigger a new entry in the new index, it won't be able > to > determine what the old entry was to remove it ... > > Cheers, > Wol > > _______________________________________________ _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
