Steve's suggestions are right on the money and have been for the past 30 years.
Virtually every one of my client's system, regardless of flavor, has had this form of clutter. Oftentimes it's just as simple as copying the VOC item to the VOCLIB (MD to PROCLIB etc) and changing the VOC item to reference the VOCLIB item. The VOC (MD) is rarely SELECTED but since all new items added to the VOC are appended to the group, the 'lumpy' effect may make certain items appear 'slower'. My 1 cent. ----- Original Message ----- From: "Stephen O'Neal" <[EMAIL PROTECTED]> To: <u2-users@listserver.u2ug.org> Sent: Sunday, October 15, 2006 5:30 PM Subject: [U2] VOCLIB and keeping VOC entries Short and Small > The intent of VOCLIB is to reduce the VOC size. One idea for speed is to > keep your VOC very small. This way the search for all items is faster. > > For some VOC items, like 'PA'ragrpahs and 'PR'ocs can be sizable (like > 1,000's of characters). This causes "Lumpy" records. (To be shocked, > sometime LIST VOC SIZE.) > > So, the intent was for people to make 'R'emote pointers and to put the > larger sized items in the VOCLIB. > > Yes, if you do this, your system will run faster. > > Example: > > ED VOC LARGE.PARAGRAPH > 1) R > 2) VOCLIB > 3) LARGE.PARAGRAPH > > ED VOCLIB LARGE.PARAGRAPH > 1) PA Some really large description of the paragraph > 2) SELECT.... > 3) LIST... > > While you are at it, you should check your VOC for overflow, which will > also slow down your system. > > For your education, > Steve > > Stephen M. O'Neal > Lab Services Sales for U2 > IBM SWG Information Management Lab Services > > > > > "Anthony W. Youngman" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 10/15/2006 01:17 PM > Please respond to > u2-users@listserver.u2ug.org > > > To > u2-users@listserver.u2ug.org > cc > > Subject > Re: [U2][UV] UO.NET Help > > > > > > > In message > <[EMAIL PROTECTED]>, Nick > Cipollina <[EMAIL PROTECTED]> writes > >Paul, > > > >Thank you very much. Turns out we were missing the VOCLIB file. This > >is a very useful piece of information. Is this documented anywhere? > > > >Thanks, > > > >Nick Cipollina > > > I've got a feeling VOCLIB isn't created automatically. It's a Pr1me-ism, > and doesn't contain anything by default, I don't think, so it's odd that > it's required. > > That said, I've never seen an INFORMATION account without it, and I > think the ODBC stuff originally came from Prime, so it's probably a > historic hangover. > > Cheers, > Wol > -- > Anthony W. Youngman <[EMAIL PROTECTED]> > 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the > thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The > man > lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 > Visit the MaVerick web-site - <http://www.maverick-dbms.org> Open Source > Pick > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
