Skip site navigation (1) Skip section navigation (2)

Re: odbc/ado problems

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Pomme Bt(dot)" <info(at)pomme(dot)hu>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: odbc/ado problems
Date: 2004-08-31 19:00:14
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3412A7492@Herge.rcsinc.local (view raw or flat)
Thread:
Lists: pgsql-performance
> thanks for the quick answer! My db driver is the native MS ADO, and
from
> Delphi i use the AODExpress components which are wrapper classes to
reach
> the ActiveX components from delhpi. The strange behaviour of that
query
> is,
> that all other queries executed in this environment are running fast,
> except
> this one. First there was any index on that table (appr. 40.000
records),
> and i thought that maybe this is my problem. Then i made this index,
but
> this hasn't solved my problem.
> Now i think that maybe the odbc driver makes something with my query?
Can
> this happen?

Possible.  I would turn on statement logging on the server and make sure
the query is the way you wrote it in the app.  The driver might be doing
something like pulling all the data and attempting a client side filter.
Otherwise you may be looking at a casting problem of some sort.

To turn on logging, set statement log to 'all' in your postgresql.conf
file.  You may need to start the server manually so you can determine
where the log goes (logging to terminal is often the easiest to work
with).

If you are writing Delphi applications, you really should check out
Zeos.  It utilizes native drivers to connect to the database...it's
really, really fast and supports all the Delphi controls (and free!).

Merlin

pgsql-performance by date

Next:From: William YuDate: 2004-08-31 19:15:22
Subject: Re: Table UPDATE is too slow
Previous:From: Matt ClarkDate: 2004-08-31 18:59:55
Subject: Re: Table UPDATE is too slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group