Re: [U2] Does anyone know the effect of adding an ndex to a UniVerse file?

2007-09-12 Thread Louie Bergsagel
The date index would contain internal-format dates, and there would be one for every record, as it is the POST.DATE. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Does anyone know the effect of adding an ndex to a UniVerse file?

2007-09-12 Thread Louie Bergsagel
I've never heard about MINIMUM.MODULUS, but then again when I did most of my operations & database work late last century, dynamic files did not exist. I've never heard of split operations either. Here are all the ANALYZE.FILE results: >ANALYZE.FILE ABC File name .. ABC ... Fil

Re: [U2] Does anyone know the effect of adding an ndex to a UniVerse file?

2007-09-12 Thread Clifton Oliver
That completely depends on how densely the index is populated. Example by extremes: If you index on a status code that has only two equally possible values, you'd have about 5.5 million records in each index. Updates to that file will grind to a near halt. If the code could have a couple of

RE: [U2] Does anyone know the effect of adding an ndex to a UniVerse file?

2007-09-12 Thread Dan Fitzgerald
:09 -0700> From: [EMAIL PROTECTED]> To: u2-users@listserver.u2ug.org> Subject: [U2] Does anyone know the effect of adding an ndex to a UniVerse file?> > Does anyone know the effect of adding an index to a UniVerse file?> > I'd like to add a date index t

[U2] Does anyone know the effect of adding an ndex to a UniVerse file?

2007-09-12 Thread Louie Bergsagel
Does anyone know the effect of adding an index to a UniVerse file? I'd like to add a date index to a type 30 file with 11 million records. ( ANALYZE.FILE Total size . 2,115,325,952 bytes) Would this have any measurable speed slowdown on applications running against the file? Th