Subject Re: [IBO] A new design
Author Daniel Rail
At 07/24/2001 04:41 AM, you wrote:
>Hello!
>I write to You becouse I am now working with same problem. I have previously
>applications working with DBF (without BDE) and when I start to use IB (with
>IBObjects) everything works much slow. Now I am trying to observe how IBO
>will work with quite large or small tables, multi table databases etc.
>
>I am interesting in writing with people who have same work and problems.
>Together is simpler to solve much problems and make many observations.
>Sorry for my english.

I've done this work over a year ago and noticed that IBO did slow down the
application a little at first. But, I also learned the different settings
for the server, the database and TIB_Connection to see how the connections
can be accelerated and did so accordingly by experimentation. I did notice
that the connections were quicker after doing some tweaking and when there
are more than one user using the application at the same time. My
application uses over 200 TIBOTable and TIBOQuery on 103 tables, I did
transfer some code to stored procedures when it was appropriate. And, when
the chance occurred, I changed a TIBOTable by a TIBOQuery. And, any future
development I would use the appropriate component. Using TIBOQuery,
TIB_Query or TIB_Cursor, you can eliminate unnecessary fields being
transferred from the server.

Just my experience. And one thing that was noticed from our clients, the
stability of the application increased dramatically compared to Paradox and
BDE. Before, there was frequent table header corruption, now none exists.

Hope this helps.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)