[U2] Index based on an I desc of TRANS data
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 greatbut just curious, Will the index get updated automatically, when the source file's data changes? (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. This is on UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
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 greatbut 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
Re: [U2] Index based on an I desc of TRANS data
It will not get updated automatically. That would be magic. For that to happen the index must be based entirely on the contents of the record and/or record id. Things like that I would tend to build the index on the key to the TRANS'd data, and maybe have another index on the field in the secondary file. An invoice file with a field that shows the customer name for example. You could index the customer name in the customer file, the customer key in the invoice file. Find the list of customer keys for a customer name, and use that to get a list of invoice records using the customer keys. But if you've got, for example, an index based on the words in the record, and you have a list of words you want to ignore (not build an index for) stored in another file - that would be a case where the source doesn't change very often and you would want to bring the system down to rebuild the index. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, November 09, 2010 3:47 PM To: U2 Users List Subject: [U2] Index based on an I desc of TRANS data 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 greatbut just curious, Will the index get updated automatically, when the source file's data changes? (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. This is on UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Index based on an I desc of TRANS data
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 greatbut 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
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. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, November 09, 2010 1:03 PM To: U2 Users List Subject: Re: [U2] Index based on an I desc of TRANS data 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 greatbut 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Index based on an I desc of TRANS data
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
Re: [U2] Index based on an I desc of TRANS data
George: The answer, in short, is /*no*/! You'll have to periodically rebuild the index. In our application we have a single address book. An entry could be associated with an A/R customer, an A/P vendor, a P/R employee, a property's unit, and a few other entity type records. When the user modifies the name, the address book's index is updated immediately but the subsidiary table's index is not (e.g. the A/R customer). We have a utility that runs upon every login to reindex the subsidiary tables that have been changed. This rebuilding is frequent enough for our purposes but you'll have to decide what frequency is appropriate for your environment. We tried to create a trigger routine that works but kept running into a deadly-embrace situation, so we gave up (at least I did). Maybe someone else has something like this working they'd like to share with all of us. HTH, Bill Haskett * / Advantos Systems, Inc./ * 4370 La Jolla Village Drive, Suite 400 San Diego, CA 92122 ☎ Tel: 360-464-2773 (WA) | ☏ Fax: 760-944-7743 What Software can be. George Gallen said the following on 11/9/2010 12:47 PM: 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 greatbut just curious, Will the index get updated automatically, when the source file's data changes? (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. This is on UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.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
