HP3000-L Archives

September 2008, Week 4

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
"Walter J. Murray" <[log in to unmask]>
Reply To:
Walter J. Murray
Date:
Sun, 28 Sep 2008 20:01:44 -0700
Content-Type:
text/plain
Parts/Attachments:
text/plain (44 lines)
Greetings,

Being on the cutting edge of HP-3000 technology here at the Department
of Corrections, we are looking into this new-fangled thing in TurboIMAGE
called B-Tree indices.  :-)

I've read the chapter in the IMAGE manual, and it all seems well
documented and straightforward.  What surprises might we encounter when
we start using this feature?

Some specific questions:

*  Does IMAGE do a good job of reliably keeping the index in sync?  Is
there ever a need to rebuild an index?

*  I read that DBSTORE doesn't know about the index files (but then who
uses DBSTORE anyway?).  Does everything else work O.K.?

*  Will I get any nasty surprises relative to performance?  

*  Are there any tutorials on B-Tree indices that would be worth
reading?

*  Are there any gotchas with B-Tree indices in DBGENERAL or ADAGER?

*  Does QUERY know anything about or take advantage of B-Tree indices?

*  I think I found one documentation error.  The manual says that IMAGE
uses KSAM XL files for the indexes, but it looks to me like it's using
KSAM64.  Are there other documentation errors I should know about?

If B-Tree indexes (I hate writing "indices" in this context!) work well,
they might provide a perfect way to implement something I'm working on
right now.

Thanks for any helpful suggestions.

Walter  

Walter J. Murray

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2