>> I was wondering if its a good idea to skip 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.

> 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

Hi Alan,

Thanks for your quick reply. I'm using Delphi with ZeosLib (correct me please if it's a bad choice). So, because they support access to MySQL, PostgreSQL, Firbird, etc..., I guess they have to use a common interface, something like an internal MemTable to store the result first. Before we used FIBPlus. (Sorry if this is off topic already).

Thank you !
N.

[Non-text portions of this message have been removed]