Wojciech,

when I started to move from desktop applications to IBO/Interbase it was
very helpfull to work with IB_WISQL and/or TIB_Query designer.

First of all look at plan section (is shown right below sql strings after
prepare) and look for "natural" orders. It means that Interbase will not use
an index to access this field. Create needing indices and avoid combined
index expressions (like in dbf index systems). It's better to have each
field in its own index.

Second: Use monitor dialog to check time. Start with simple queries and
expand expression step by step just with a look of time consuming tasks.

Third: Use inline selects instead of joins (e.g. select (select name from
table1 t1 where t1.nr=t2.nr) as name, t2.* from table2 t2 where ...)

Last tip: If things become more complicated just use stored procedures
instead of "plain queries".

HTH.
Mit freundlichem Gruss & Best Regards

Andreas Pohl
apohl@...
www.ibp-consult.com

----- Original Message -----
From: "Wojciech Materna (2)" <wm@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, July 24, 2001 9:41 AM
Subject: Re: [IBO] A new design


> 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.
>
> Wojciech Materna
> wm@...
>
>
>
> ----- Original Message -----
> From: <rod@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Monday, July 23, 2001 10:23 AM
> Subject: [IBO] A new design
>
>
> > 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. 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 ? Has
> > anyone read the 'Getting started with IBObjects' and will it help ?
> >
> >
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>