RE: MS Access 97 SR-1, psqlodbc 7.01.00.06, slow perfomance

From: "Jeff Johnson" <jeff(at)jeffjohnson(dot)net>
To: 'Juri Fjodorov' <jyri(dot)fjodorov(at)nowecanspam(dot)ee>, <pgsql-interfaces(at)postgresql(dot)org>
Subject: RE: MS Access 97 SR-1, psqlodbc 7.01.00.06, slow perfomance
Date: 2001-07-16 18:38:01
Message-ID: B9C9130B5D27D4119D5D00A0C9D3A987109500@SERVER
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

> problem is, when i do something(anything) with bounded
> form/report(changing text box source, for example), access makes
> connection to backend. i dont realy know what it do there as i am a
> newbie at postgres, but its real pain in the butt with about 1000K
> records in few tables. you see, i dont like to wait 2 mins just for
> changing text box source.

I hope it doesn't "select count(*)" anywhere. Postgres is painfully
slow for doing that. I'm a postgres newbie so hopefully someone knows
a workaround or knows that they're working on improving it.

Browse pgsql-interfaces by date

  From Date Subject
Next Message Bruce Momjian 2001-07-16 20:12:55 Re: LIBPQ WIN32 NON-BLOCKING
Previous Message Manika Dey 2001-07-16 14:54:01 postgres access from windowsNT