Haci Yigit wrote:

> I use IBQuery in the project. An i select only necessary fields not=20
> all. Such as "Select name, surname, grup from...." and in this table=20
> record # is 12. Table size is very small.
>
> FireBird version 1.5

Check how long a prepare takes, and then check the select, and then check
the time to transfer the records. I don't use IBX, but with IBO it is
something like (after connect and setting up the query):
// Time 0
Q1.prepare;
// Time 1
Q1.First;
// Time 2
while not Q1.Eof do
Q1.Next;
// Time 3
Q1.Close;
// Time 4

Which part(s) is slow/slowest?

--
Aage J.