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

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 (view raw or flat)
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
> 

pgsql-interfaces by date

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

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