Subject Re: [IBO] IBO 5.9.3 Build 2631 is released.
Author Mauro Rocha
Seems like this link is broken:

http://www.ibobjects.com/ Optimizing%20Queries%20and% 20Transactions.rtf

On Thu, Jun 22, 2017 at 9:22 PM, supportlist@... [IBObjects] <IBObjects@yahoogroups.com> wrote:
 

All,


I am delighted to announce the official release of IBO 5.9.3 Build 2631 today.  This release provides support for the latest version of Delphi and C++ Builder as well as some other significant improvements.

For all of the details, please see the Release Notes here:
www.ibobjects.com/ ReleaseNotes.rtf



One of the most noteworthy accomplishments for this release is a significant improvement in the horizontal dataset refinement capability of IBO.  If you don't know what this is then you will definitely want to take notice of this.  It makes it so that large queries can be navigable with similar efficiency as flat file local database tables could be.  There is a level of intelligence built into IBO that breaks apart your query into several cursors so that you can navigate to anywhere in your dataset.  If you set a bookmark, call Locate(), use Refresh and want to keep your record position, call the Last method, etc. it will happen virtually instantaneously no matter how large your dataset is.  Prior to this release I only used the first column of the ORDER BY clause to perform this optimization, but I have no enhanced things so that it will take the first 3 columns into consideration when optimizing things.  This is ideal for a database that has the last name and the first name and a middle name as the sort order.

I have included an additional documentation file that I also highly recommend all of my customers/users become familiar with.  There are some new improvements in IBO that this document helps to explain and show you how to use them, as well as understand how they work.


Please have a look at the Optimizing Queries and Transactions file here:
http://www.ibobjects.com/ Optimizing%20Queries%20and% 20Transactions.rtf


I also wish to extend my heartfelt appreciation for everyone's patience as I have taken longer than I would like to of to get this release out.  There have also been many who have been very helpful to me to solve some of the issues I needed to iron out before this release could be made.


I encourage all of my customers to please consider making an upgrade if your source access subscription has expired.  IB Objects continues to be my "day job" and my focus.  If anyone has any projects they would like my help with as a consultant, I am always interested in taking on short-term projects as it always helps for me to keep my feet planted in your real-world applications.  Please inquire about terms and rates.

Kind regards,

Jason Wharton

www.ibobjects.com






--

==================================================
Mauro Nacif Rocha
Departamento de Informática
Universidade Federal de Vi├žosa - MG - Brasil
mnacif@...    http://www.dpi.ufv.br/~nacif/
tel.: (31) 3899-1775 / 3891-5133 / 99965-0323
==================================================