Subject | IBOTable Last |
---|---|
Author | Sandeep |
Post date | 2001-10-28T20:59:33Z |
When procedure Last is called the IBOTable seems to be reading
all the records on the server, but when I create an Descending
index it works fine.
The only advantage I found of Descending index is when doing last.
There seems to be no speed improvement when scrolling up/down
the table. What I think could be done (IMHO) is to make a sql
statement like this
select * from tableA
where fieldA = (select max (fieldA) from tableA)
when procedure Last is called. I don't know how difficult it will be
because I don't know how the sql statements are made.
Regards
Sandeep
Software Developer
CFL
sandeep@...
http://www.cfl.co.nz
all the records on the server, but when I create an Descending
index it works fine.
The only advantage I found of Descending index is when doing last.
There seems to be no speed improvement when scrolling up/down
the table. What I think could be done (IMHO) is to make a sql
statement like this
select * from tableA
where fieldA = (select max (fieldA) from tableA)
when procedure Last is called. I don't know how difficult it will be
because I don't know how the sql statements are made.
Regards
Sandeep
Software Developer
CFL
sandeep@...
http://www.cfl.co.nz