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 [email protected] To [email protected] 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 [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
