> Hi,
> I develop under Delphi7(Build 8.1) pgexpress 4.01 and postgreSQL 8.1.2
> OS is windows XP Professional or Windows 2003 Server.
> In my project i use dbexpress components TSQLConnection, TSQLQuery ->
> TDataSetProvider -> TClientDataSet.
> In some situations when the TClientDataSet excute action
> "TClientDataSet.Open" this freeze the aplication and CPU Usage is over 95%.
> This situation happen only when the server is native windows.
> If necessary i have one project and database for example.
this is more appropriate in pgsql-general.
anyways, turn on your query logging and find if the problem is begin
generated from your app or the dbexpress middleware. sounds to me
like the ususal tcp problem which is usually configuration related.
also check out zeos database components for a fantastic set of
components for delphi.
Merlin