MySQL Forums
Forum List  »  Other Migration

Re: Btrieve API style access
Posted by: Larry Irwin
Date: August 17, 2007 11:07AM

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.

Options: ReplyQuote


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.