Page 1 of 1

TUniTable.IndexFieldNames: populating takes very long

Posted: Wed 03 Feb 2010 01:39
by jbakuwel
Hi,

TUniTable connected to large PostgreSQL table.

TUniTable.SpecialOptions.FetchAll = False
TUniTable.Active = True (returns quickly)

Populating the list of fields in IndexFieldNames takes very long (as if the full table contents are pulled from the server)?

Any ideas?

Jan

Posted: Wed 03 Feb 2010 11:58
by Challenger
The IndexFieldNames property enables local sorting. To avoid this situation use the OrderFields property.