Subject | Last() Method |
---|---|
Author | yakara_2 |
Post date | 2007-09-02T10:25:26Z |
Some days ago, I downloaded the IBObjects components for testing.
I have one problem with Interbase/Firebird databases and I want to
know if it is possible to solve it with IBObjects.
I'm working with a remote connection to databases and I have a table
with lots of records, when I use the Last()method to go to the last
record in table (I'm in a grid) I have to wait lots of time.
How Can I speed up this situation?
The table has a primary key and I tried to create a second index
that is the same that primary key but in reverse order (with desc),
but the speed is the same.
Thanks in advance.
Angel M. Aranguren
I have one problem with Interbase/Firebird databases and I want to
know if it is possible to solve it with IBObjects.
I'm working with a remote connection to databases and I have a table
with lots of records, when I use the Last()method to go to the last
record in table (I'm in a grid) I have to wait lots of time.
How Can I speed up this situation?
The table has a primary key and I tried to create a second index
that is the same that primary key but in reverse order (with desc),
but the speed is the same.
Thanks in advance.
Angel M. Aranguren