Re: Btrieve API style access
You are surely referring to "handles", which provides this type of interface to the tables. Cursors do the same thing.
With them you can specify which index to follow.
I haven't used them, but I am in the process of converting 300 servers that have Faircom's CTree ISAM files, so I know the conceptual shift you are experiencing.
(i.e. Where's the index? [it's there] How do I traverse the index? [generally, you don't] and things like that...)
General Notes to get away from Handles/Cursors:
Combine like tables into one. JOINS are slower.
Anywhere you created things like Note1 and Note2, combine them.
Convert all date formats to DATE (vs. custom julian,etc.).
Convert all time formats to TIME
Create lots of indeces on your tables as needed whenever performance is slow.
Subject
Views
Written By
Posted
6237
July 30, 2007 04:07AM
Re: Btrieve API style access
3364
August 17, 2007 11:07AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.