From: Jüri Fjodorov <jyri.fjodorov@nowecanspam.ee>
To: pgsql-interfaces@postgresql.org
Subject: MS Access 97 SR-1, psqlodbc 7.01.00.06, slow perfomance
Date: Tue, 10 Jul 2001 17:26:12 +0300
Message-ID: <3B4B1084.4C0C0E1B@nowecanspam.ee> (raw)
hi all!
im just trying to migrate my ms access back-end to postgres. i used
pgadmin for it and now i have tables stored in postgres on mandrake 7.2
server. frontend is still ms access.(at least im trying redoing it for
postgres..)
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 have strange feeling that its not normal and something configured
wrong. why access have to access backend all the time while i am in
form/report edit mode?
anyone can help me out?
thanx in advance
jyri
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jyri.fjodorov@nowecanspam.ee
Subject: Re: MS Access 97 SR-1, psqlodbc 7.01.00.06, slow perfomance
In-Reply-To: <3B4B1084.4C0C0E1B@nowecanspam.ee>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox