<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:st1 =
"urn:schemas-microsoft-com:office:smarttags"><HEAD><TITLE>Sequentially Retreiving an Indexed file in the order they were inserted</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]--><o:SmartTagType
downloadurl="http://www.5iamas-microsoft-com:office:smarttags" name="City"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
downloadurl="http://www.5iantlavalamp.com/" name="place"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><!--[if !mso]>
<STYLE>st1\:* {
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Tahoma;
}
@font-face {
font-family: Trebuchet MS;
}
@page Section1 {size: 8.5in 11.0in; margin: .7in .7in .7in .7in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle18 {
FONT-WEIGHT: normal; COLOR: blue; FONT-STYLE: normal; FONT-FAMILY: "Courier New"; TEXT-DECORATION: none; mso-style-type: personal
}
SPAN.EmailStyle19 {
FONT-WEIGHT: normal; COLOR: blue; FONT-STYLE: normal; FONT-FAMILY: "Courier New"; TEXT-DECORATION: none; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
OL {
MARGIN-BOTTOM: 0in
}
UL {
MARGIN-BOTTOM: 0in
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue bgColor=#ffffff>
<DIV><FONT face=Arial size=2>and 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 ;)</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=Tremblay.Pierre-McLeod@hydro.qc.ca
href="mailto:Tremblay.Pierre-McLeod@hydro.qc.ca">Tremblay.Pierre-McLeod@hydro.qc.ca</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=IOlson@saputo.com
href="mailto:IOlson@saputo.com">IOlson@saputo.com</A> ; <A
title=powerh-l@lists.sowder.com
href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, May 02, 2006 8:01 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: Sequentially Retreiving an
Indexed file intheordertheywereinserted</DIV>
<DIV><BR></DIV>
<DIV><FONT face="Trebuchet MS" color=#0000ff size=2><SPAN
class=012475218-02052006>And that's it.</SPAN></FONT></DIV>
<DIV><FONT face="Trebuchet MS" color=#0000ff size=2><SPAN
class=012475218-02052006>Ingemar just made the final
statement.</SPAN></FONT></DIV>
<DIV><FONT face="Trebuchet MS" color=#0000ff size=2><SPAN
class=012475218-02052006></SPAN></FONT> </DIV>
<DIV><FONT face="Trebuchet MS" color=#0000ff size=2><SPAN
class=012475218-02052006>Anyway, Thanks for your help
guys.</SPAN></FONT></DIV>
<DIV><FONT face="Trebuchet MS" color=#0000ff size=2><SPAN
class=012475218-02052006>It's always a pleasure to see there is still good and
friendly Powerhouse people around.</SPAN></FONT></DIV>
<DIV><FONT face="Trebuchet MS" color=#0000ff size=2><SPAN
class=012475218-02052006></SPAN></FONT> </DIV>
<DIV><FONT face="Trebuchet MS" color=#0000ff size=2><SPAN
class=012475218-02052006><U><FONT face="Trebuchet MS"
size=2>
</FONT></U><BR><FONT face="Trebuchet MS" size=2>Pierre McLeod Tremblay</FONT>
<BR><FONT face="Trebuchet MS" size=2>Consultant T.I. / I.T. Consultant</FONT>
<BR><FONT face="Trebuchet MS" size=2><A
href="mailto:pmcleod@videotron.ca">pmcleod@videotron.ca</A></FONT> <BR><FONT
face="Trebuchet MS" size=2>819.263.0791 fax: 819.263.0792</FONT> <BR><FONT
face="Trebuchet MS"
size=2>
cell: 819.692.6666</FONT> </DIV>
<DIV>
<P><FONT face="Trebuchet MS" size=2>Chez Hydro:</FONT> <BR><FONT
face="Trebuchet MS" size=2><A
href="mailto:tremblay.pierre-mcleod@hydro.qc.ca">tremblay.pierre-mcleod@hydro.qc.ca</A></FONT>
<BR><FONT face="Trebuchet MS" size=2>819.298.2943 poste 7411</FONT>
</P></SPAN></FONT></DIV>
<DIV><FONT face="Trebuchet MS" color=#0000ff size=2><SPAN
class=012475218-02052006></SPAN></FONT> </DIV>
<DIV><FONT face="Trebuchet MS" color=#0000ff size=2><SPAN
class=012475218-02052006></SPAN></FONT> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Message d'origine-----<BR><B>De :</B> Olson, Ingemar
[mailto:IOlson@saputo.com]<BR><B>Envoyé :</B> 2 mai 2006
14:42<BR><B>À :</B> Tremblay, Pierre McLeod;
powerh-l@lists.sowder.com<BR><B>Objet :</B> RE: Sequentially Retreiving
an Indexed file in theordertheywereinserted<BR><BR></FONT></DIV>
<DIV><SPAN class=874213718-02052006><FONT face="Lucida Sans Unicode"
color=#0000ff size=2>RMS stores data records in an indexed file according to
the primary key value.</FONT></SPAN></DIV>
<DIV><SPAN class=874213718-02052006><FONT face="Lucida Sans Unicode"
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=874213718-02052006><FONT face="Lucida Sans Unicode"
color=#0000ff size=2>If you have timestamp information stored in the data
records, eg, then you have the possibility of creating a new index using
these fields.</FONT></SPAN></DIV>
<DIV><SPAN class=874213718-02052006><FONT face="Lucida Sans Unicode"
color=#0000ff size=2>If there is no such information then this is just not
possible.</FONT></SPAN></DIV>
<P><FONT face="Times New Roman">Ingemar Olson</FONT> <BR><FONT
face="Times New Roman">Dairyland IT Department, Sperling </FONT>
<BR><B><FONT face=Garamond size=5>S</FONT><FONT face=Garamond
size=4>APUTO</FONT> <FONT face=Arial size=1>FOODS LIMITED</FONT></B>
</P></BLOCKQUOTE>
<P>
<HR>
<P></P>-- <BR>= = = = = = = = = = = = = = = = = = = = = = = = = = =
=<BR>Mailing list: powerh-l@lists.sowder.com<BR>Subscribe:
&quot;subscribe&quot; in message body to
powerh-l-request@lists.sowder.com<BR>Unsubscribe: &quot;unsubscribe
&lt;password&gt;&quot; in message body to
powerh-l-request@lists.sowder.com<BR>http://lists.sowder.com/mailman/listinfo/powerh-l<BR>This
list is closed, thus to post to the list you must be a subscriber.<BR>Add
'site:lists.sowder.com powerh-l' to your search terms to search the list
archive at Google.</BLOCKQUOTE></BODY></HTML>