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

From: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
To: 'Jüri 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-18 09:09:07
Message-ID: E2870D8CE1CCD311BAF50008C71EDE8E01F7461C@MAIL_EXCHANGE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hello,
That does sound rather a long time. Check the driver options to see
if logging is enable. Also check to see if ODBC is tracing. Make sure both
these options are of. Also unles you use the fetch option I *think* the ODBC
driver will just try and upload the entire result of the query (which will
take a loooong time if you don't have a where clause on a million row
table). When you say changing text box source do you mean the text boxes
Control Source or the actual data? Do both take a long time or only one?
What is the Record Source for the form? Is it a passthrough query or a
linked table? Also if its based on a join, MS Access joins a slow. For help
on ODBC problems there is a mailing list on
pgsql-odbc(at)postgresql(dot)org
Hope this helps,
- Stuart

> -----Original Message-----
> From: Jüri Fjodorov [SMTP:jyri(dot)fjodorov(at)nowecanspam(dot)ee]
> Sent: Tuesday, July 10, 2001 3:26 PM
> To: pgsql-interfaces(at)postgresql(dot)org
> Subject: MS Access 97 SR-1, psqlodbc 7.01.00.06, slow perfomance
>
> 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
>

Browse pgsql-interfaces by date

  From Date Subject
Next Message László Tibor 2001-07-18 10:32:26 RE: ODBC Problem
Previous Message Henshall, Stuart - WCP 2001-07-18 08:58:17 RE: ODBC Problem