Hi all,

I was reading your comment about speed of interbase with and
without tables and I wish to tell you about my little experience
using Interbase with delphi. I had a query that was used many
times in my code that made a selection "where client_id = xxx"
and I noticed that the the procedure that used it performed so
slowly so I used a profiler (GpProfile by Primoz Gabrijelcic) and I
saw that the problem was with that query. Whithout making any
change to my code I added an index on the field clien_id of the
table and remade the test and the time used by the quey was
1/100 of the previous. I couldn't beleive it so I deleted the index and
tried it again and the time was bad as the first time so I created the
index again and I got again the 100 time beter time. I repeated the
test and I got always the same result.

Ibrahim