Locate very slow when table record > 1000,000 rec
Posted: Sat 05 Apr 2008 19:57
Hi CoreLab team
suppose you have a table with >= 1000,000
when you want to locate a record that accidental in a last last record in
your table, Locate very very slow to find this record !!!!
Example :
T1 : (Filed1, Field2, ...) (Field1 is PK)
Table Values :
1,....
2,....
3,....
4,....
.
.
.
.
1000000,...
Now :
T1.Locate('Field1', 1000,000, []) -> Very Very Slow
( Please dont tell me to use Query for found this record ! )
Thanks for your Advice and your the best of the best Packages
suppose you have a table with >= 1000,000
when you want to locate a record that accidental in a last last record in
your table, Locate very very slow to find this record !!!!
Example :
T1 : (Filed1, Field2, ...) (Field1 is PK)
Table Values :
1,....
2,....
3,....
4,....
.
.
.
.
1000000,...
Now :
T1.Locate('Field1', 1000,000, []) -> Very Very Slow
( Please dont tell me to use Query for found this record ! )
Thanks for your Advice and your the best of the best Packages