Sequentially Retreiving an Indexed file intheordertheywereinserted

[Joe Boyle]

Sequentially Retreiving an Indexed file in the order they were insertedand this information explains why data bucket splits occur, or more significantly why they occur; in order to maintain the primary key order for when accessing sequentially ;)
  ----- Original Message ----- 
  From: Tremblay.Pierre-McLeod at hydro.qc.ca 
  To: IOlson at saputo.com ; powerh-l at lists.sowder.com 
  Sent: Tuesday, May 02, 2006 8:01 PM
  Subject: RE: Sequentially Retreiving an Indexed file intheordertheywereinserted


  And that's it.
  Ingemar just made the final statement.

  Anyway, Thanks for your help guys.
  It's always a pleasure to see there is still good and friendly Powerhouse people around.

                                                                      
  Pierre McLeod Tremblay 
  Consultant T.I. / I.T. Consultant 
  pmcleod at videotron.ca 
  819.263.0791 fax: 819.263.0792 
                       cell: 819.692.6666 
  Chez Hydro: 
  tremblay.pierre-mcleod at hydro.qc.ca 
  819.298.2943 poste 7411 



    -----Message d'origine-----
    De : Olson, Ingemar [mailto:IOlson at saputo.com]
    Envoyé : 2 mai 2006 14:42
    À : Tremblay, Pierre McLeod; powerh-l at lists.sowder.com
    Objet : RE: Sequentially Retreiving an Indexed file in theordertheywereinserted


    RMS stores data records in an indexed file according to the primary key value.
    If you need to access them in a different sequence you'll have to add a key or sort them on some data field(s) that represent the sequence you want.
    If you have timestamp information stored in the data records, eg, then you have the possibility of creating a new index using these fields.
    If there is no such information then this is just not possible.
    Ingemar Olson 
    Dairyland IT Department, Sperling   
    SAPUTO FOODS LIMITED 



------------------------------------------------------------------------------


  -- 
  = = = = = = = = = = = = = = = = = = = = = = = = = = = =
  Mailing list: powerh-l at lists.sowder.com
  Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
  Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request at lists.sowder.com
  http://lists.sowder.com/mailman/listinfo/powerh-l
  This list is closed, thus to post to the list you must be a subscriber.
  Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060505/cdbe4bcb/attachment.htm