I agree with both setting a min modulus AND doing a CLEARFILE if the file is empty.
Just remember that if an empty file has a big modulus, it can still take some time for the select to chug through all the groups. That time will be determined by the mod and the performance of your machine. John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OHÂ 45342 937-866-0711 x44380 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Anthony W. Youngman Sent: Wednesday, October 21, 2009 3:52 AM To: [email protected] Subject: Re: [U2] Sequentially Hashed Files In message <6e8c6c3ab287df45837a5816ce37531d68d6544...@daconosbserver.daconosbs.loca l>, David Jordan <[email protected]> writes >Hi Ray > >Are you using UniVerse or UniData. I use dynamic files and never have >to resize them in UniVerse. > The OP said that the files keep on growing and shrinking - and that is not good for dynamic files. Although I would ask why you have to keep resizing and generally "maintaining" the files? You shouldn't have to do that with dynamic files (unless, of course, you're short of disk space and overflow wastes huge amounts). I'd go with Adrian's suggestion and use MINIMUM.MODULUS. *However* you did say the files regularly get emptied. Do you have an app that processes the file and empties it? If it's disk space you're worried about, just do a CLEAR.FILE inside your app once you've emptied the file - I think you can do it as a basic statement rather than an execute. You'll need to look at how to do it (it should be very simple) but I'd be inclined to do the below on every file after it's processed lock file clearselect select file if count = 0 then clearfile release That's all your maintenance and disk freeing automated for you... 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] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
