Jean-Max Reymond a écrit :
>I have very poor access whith a front end Access 2003, ODBC and Postgres 7.4.3.
>Much time to find a record in a table ff 13000 records with indexs.
>Sniffing the network, I can see a lot of traffic and the CPU of
>postmaster is about 30% (P4, 2.8 GHz). It seems that all the data's
>are backed on the client side and then, analyzed.
>Does it exist an option to improve the performances ?
Maybe you can use the EXPLAIN command to see what query plan the system
creates for your query (you can see the where condition, which index is
In response to
pgsql-odbc by date
|Next:||From: Jean-Max Reymond||Date: 2004-07-29 13:18:52|
|Subject: Re: bad performance for Access, ODBC and Postgres|
|Previous:||From: Jean-Max Reymond||Date: 2004-07-29 12:34:01|
|Subject: bad performance for Access, ODBC and Postgres|