No BDE components are used here, this is C++ with native FB API.

--- In firebird-support@yahoogroups.com, David Johnson
<johnson_d@...> wrote:

>
> It is a bad idea to use BDE components with an RDBMS. BDE

components

> were written from an ISAM world view. They expect your app to have
> total control of the storage hardware, and they are uncomfortable

with

> delegating control of the hardware to another application (the

RDBMS,

> firebird in this case).
>
>
> On Mon, 2006-03-27 at 14:35 +0000, Glebas wrote:
> > Thanks Tim, I see your point, but if the code is not optimal -
> > I expect things go slowly every day but what I see is that things
> > are usually fast but go down in a nasty way twice a week. :)
> >
> >
> > --- In firebird-support@yahoogroups.com, Tim <tim@> wrote:
> > >
> > > Write better code. :D
> > >
> > > (in Delphi terms)
> > >
> > > A TTable is a query that returns a subset of ALL the rows in a
> > table.
> > > (LOTS of network traffic) When you scroll through the table,

it

> > re -
> > > runs the query as soon as you go beyond the subset you have

asked

> > for.
> > >
> > > A TQuery is a query that (as far as I understand it) returns a
> > subset
> > > of what you ask for, plus some rows on either side.
> > >
> > > A TStoredProcedure returns EXACTLY what you ask for. Nothing

more,

> > > nothing less.
> > >
> > > Now, I'm no expert. I may have the details wrong. (I probably

have

> > > the details wrong :)) But even with that, a stored procedure

is

> > the
> > > fastest way or returning data AND keeping the network traffic

down.

> > >
> > > Added to the above, the exact design of your query can also

have

> > an
> > > effect on network traffic. SELECT * FROM ABC obviously returns
> > more
> > > data than SELECT ROWNUMBER, CLIENTNAME from ABC.
> > >
> > > HTH
> > >
> > > Tim
>