TUniTable.IndexFieldNames: populating takes very long

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jbakuwel
Posts: 35
Joined: Tue 02 Feb 2010 04:47

TUniTable.IndexFieldNames: populating takes very long

Post by jbakuwel » Wed 03 Feb 2010 01:39

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

Challenger
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Wed 03 Feb 2010 11:58

The IndexFieldNames property enables local sorting. To avoid this situation use the OrderFields property.

Post Reply