Subject RE: [firebird-support] Direct FB access
Author Alan McDonald
>
> Hi all,
>
> A while ago, I read a post about accessing FBClient directly.
> I have to read a range of records, and store them in a List object that
> is made up of those records. So I have to load first those records in
> a query and then copy them all to a List object. Seems a bit waste of
> time storing them first in a query. I was wondering if its a good idea
> to skip that query and access FBClient directly ? Or am I wasting my
> time to such a solution ? Maybe its complex and worthless ?
> I'm just trying to find the most performant design.
>
> Many thanks in advance.
> N.
>

I'd recommend using the component set you currently use (you don't say).
Just use the correct one. e.g. a cursor component is non buffered and is
designed for this specific purpose. You open it, traverse it once from top
to bottom and close it.
Depends on which connection set you use but they should have such a
component which executes without delay and is very light weight in your
application.
Alan