UniData has a CONFIGURE.FILE verb - I'd have thought UniVerse had it too. This allows you to set the MINIMUM.MODULUS on an existing file to make it bigger.
Cheers, Ken -----Original Message----- From: Allen Egerton Martin Phillips wrote: > Hi Allen, > >> If I know in advance that I'm adding a large number of records >> to a file, is there any way to force the file to "grow" in advance? > > You could do this with the MINIMUM.MODULUS parameter but the whole point > of dynamic files is that they do their own tuning. Although a dynamic > file is unlikely to be as good as a perfectly tuned static file, it will > be a lot better than a typical static file that has been left alone for > a long while. > > Another important point is that a split affects only one (or arguably > two) groups unlike resizing a static file from modulo N to modulo N+1 > which would affect every group. > > My real point here is that it is usually best to let a dynamic file look > after itself. In general I'd agree with you. The situation is that I'm potentially adding a million records to a dynamic file. That's not hypothetical, it's a real life scenario. And I don't want to wait while the file splits multiple times over the course of the add. I don't have that large a window. I want to force the file to expand the weekend before so that when I add the records the file isn't rebuilding. The file's already dynamic, so setting Minimum.Modulus doesn't seem to do me much good unless I can figure out how to force it to split to that minium.modulos. And there's the crux of my question. How can I force it to split? The file's numerically keyed, (sequential), so it hashes pretty evenly across the groups, consequently I'm not overly worried about empty groups due to forcing the splits beforehand. I know this isn't how you, (or I), typically work with dynamic files. I've got some slightly unusual circumstances and client induced constraints that I'm working under. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
