Subject Re: [IBO] A new design
Author Svein Erling Tysvær
>I am doing a conversion from BDE Paradox (D5) to IBO. The datasets are
>getting quite large now, hence the need for change. The application used
>TTables, always active and connected to the database. I have converted to
>IBObjects and things are MUCH slower.

As expected - no good client/server database should be able to compete with
a desktop database in applications designed with a desktop database in mind.

>I do understand that the design our app is running under is completely wrong
>for a RDBMS database. A properly structured redesign is required. The
question
>- what is recommended documentation / books that give good instruction on
this
>design ?

The most important thing to do is to only get those records that are
needed, not entire tables. You could improve your performance dramatically
without doing all too drastic changes to your program. I think Helen has a
book she really recommends. Let's see... According to
www.interbase2000.org/bookstore that should be "Data Modeling Essentials:
Analysis, Design and Innovation (2nd Edition) by Graeme Simsion, revised
and updated by Graham Witt and Graeme Simsion"

>Has anyone read the 'Getting started with IBObjects' and will it help ?

The Getting started guide will help you a lot regarding how to use IBO and
you should buy it. But it assumes you already know Database Design, and
doesn't help you with that at all.

Set