Hi,

I was look at ibobjects and I built a test application to see
how much improvement I would get by moving from Paradox to
Interbase on a large database (120K records). I converted the
data from paradox using the IBPump tool from Clever Components.
That worked fine. In paradox I have an index by Name and record
number (Name; MyRecNum). I built a simple database/table/grid
app and noticed that it worked fine but when I hit Last there was
a large time delay.

I remembered something about adding a desc index to reduce this.
I added a new index on name and record number that is desc and it
still takes as long.

I did set the IndexFieldNames to Name;MyRecNum and I am using a
TIBOTable but when I do a last it takes 1 or 2 minutes to return.
Is there a way to tell what index is being used?

Is there something else I need to set? I am using Delphi 5,
Firebird 1.5 and the newest trial of IBObjects.

Thanks,

Joseph Gordon