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
>