Re: Secondary Keys

["paul cunnane" <paul@xxxxxxxxxxx>]

> User Indexes are wonderful for small lists that don't change a lot, like
> tables, but they have severe limitations.  If I recall correctly, it was
> something like no more than 2,000 records of no more than 2,000 bytes
each,
> or something like that.  It might be ok for loading a subfile from if you
> are not loading too many records at a time.

The 2,000 byte limit is correct, but the maximum size of a user index is
4GB, which yields a maximum of over two _million_ records.

I believe they are very fast, also.  Probably a lot faster than files for
relatively small record counts.  Certainly it's a lot quicker to create a
temporary user index (CALL QUSCRTUI) than to create a temporary file.

--
Paul


+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---