RefreshRecord Slow

RefreshRecord Slow

Postby Claudio » Thu 10 Jun 2010 17:52

DLL Version: 1.10.0.8

Delphi 2010.

Parameters;

HostName=localhost
DataBase=test
DriverName=DevartPostgreSQL
User_Name=postgres
OIDAsLargeObject=True
DetectParamTypes =True
UseUnicode=True

When I give a RefreshRecord it loads all the data first, and only after the selected record, I saw on the monitor.

Please investigate.

Thanks.
Claudio
 
Posts: 25
Joined: Tue 17 Mar 2009 12:47

Postby bork » Fri 11 Jun 2010 11:23

Hello

Please provide the following information: is your TSQLQuery or TSQLTable open before calling the RefreshRecord method or not.
bork
Devart Team
 
Posts: 643
Joined: Fri 12 Mar 2010 07:55

Postby Claudio » Fri 11 Jun 2010 16:09

Hi,

I'm using TSimpleDataSet.

Thanks.
Claudio
 
Posts: 25
Joined: Tue 17 Mar 2009 12:47

Postby bork » Mon 14 Jun 2010 09:41

Try to set the TSimpleDataSet.DataSet.Active property to True. In this case TSimpleDataSet will not reopen internal dataset on each RefreshRecord.
bork
Devart Team
 
Posts: 643
Joined: Fri 12 Mar 2010 07:55


Return to dbExpress driver for PostgreSQL