RE: Secondary Keys

["Smith, Nelson" <NSmith@xxxxxxxxxxx>]

I'm glad to hear this Paul.  I was a little worried about some of my tables
going over 2,000 records.  I can live with the 2,000 byte limit ok.  They
are extremely fast for repeated use once they are built.  For high use
tables and such, I build them once at the beginning of a job and then it is
much faster to access it than to chain to a table file.

> -----Original Message-----
> From: paul cunnane [SMTP:paul@cunnane.net]
> Sent: Thursday, December 07, 2000 12:11 PM
> To:   RPG400-L@midrange.com
> Subject:      Re: Secondary Keys
> 
> > 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
> +---


************************************************************************************************************************************************************************************************************
This message originates from Lincare Holdings Inc. It contains information 
which maybe confidential or privileged and is intended only for the individual 
or entity named above.
It is prohibited for anyone else to disclose, copy, distribute or use the 
contents of this message. 
All personal messages express views solely of the sender, which are not to be 
attributed to Lincare Holdings Inc., and may not be copied or distributed 
without this disclaimer. 
If you received this message in error, please notify us immediately at 
MailAdmin@lincare.com or (800) 284-2006.
************************************************************************************************************************************************************************************************************
+---
| 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
+---