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

Re: bad performance for Access, ODBC and Postgres

From: "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>
To: "Jean-Max Reymond" <jmreymond(at)gmail(dot)com>,<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: bad performance for Access, ODBC and Postgres
Date: 2004-07-29 13:23:57
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc

Can you give us some more informations regarding the way you link Access and Postgresql? Linked table? Pass-through query?
How do you query the table? With an Access filter?

In order to get the best performance, I suggest you put all the logic on the database, and use a pass-through query to query the postgresql view or function.

-----Message d'origine-----
De : pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] De la part de Jean-Max Reymond
Envoyé : jeudi, 29. juillet 2004 14:34
À : pgsql-odbc(at)postgresql(dot)org
Objet : [ODBC] bad performance for Access, ODBC and Postgres

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 ?

Jean-Max Reymond
CKR Solutions

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

pgsql-odbc by date

Next:From: Antonio PenninoDate: 2004-07-29 15:33:13
Subject: Re: problem with CVS version
Previous:From: Jean-Max ReymondDate: 2004-07-29 13:18:52
Subject: Re: bad performance for Access, ODBC and Postgres

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