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