Thread: Situation with delphi7 x postgresql 8.1.2

Situation with delphi7 x postgresql 8.1.2

From
"Marcio"
Date:
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.
 
Thanks,
Márcio
 
 

Re: Situation with delphi7 x postgresql 8.1.2

From
Merlin Moncure
Date:
> 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


Re: Situation with delphi7 x postgresql 8.1.2

From
Gustavo Tonini
Date:
zeos was better than dbexpress with postgresql and mysql in my test
applications...connections were several seconds faster with zeos

Gustavo.

2006/2/8, Merlin Moncure <mmoncure@gmail.com>:
> > 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>