From: Valerio Santinelli <tanis@mediacom.it>
To: pgsql-interfaces@postgresql.org
Subject: [Fwd: [GENERAL] Slow Searches using MSAccess and ODBC to aPostGreSQL database]
Date: Wed, 30 Dec 1998 11:43:08 -0100
Message-ID: <368A1FDC.62605DB3@mediacom.it> (raw)
I hope someone can come up with a solution to this one..
David Hartwig wrote:
> dustin sallings wrote:
>
> > On Fri, 18 Dec 1998, Valerio Santinelli wrote:
> >
> > What does the query look like, and what does the table look like?
> >
> > // I've just setted up my PostGreSQL database on a Linux machine and it
> > // seems to work fine with the radius daemon i'm currently working on.
> > //
> > // Now I need to interface it with MSAccess to access data about our
> > // customers and other stuff stored in the postgres database. It seems to
> > // work correctly as to insertion, update and so on, but when I'm doing a
> > // search on every field on a substring it gets something like 2 minutes
> > // and a half to look in a 1500 records database and you all know that'd
> > // way too much.
> > // The search is on 8 fields on a single table.. what could I do to speed
> > // it up ? (When i was running this database just on Access it took at most
> > // 2 seconds for the whole search)
> > //
> > // I gave a look to the log and it seems that for every search on a single
> > // record it involves seven transactions on the same record.. that sounds
> > // strange to me.. anybody who can help me out ?
>
> Welcome to the world of remote data access via the MS Jet.
>
Heh... I think that's not a good point ;)
> Are you using the search/filter mechanism while browsing a table, or a query in
> the query designer?
I'm just using the search command built into MSAccess while browsing a form.
> Which version of backend and driver?
PostgreSQL v6.4 with the latest ODBC driver.
> Is there a primary key of which MS Access is aware?
There's an ID field that is used as a primary key but it seems that it's not
influent in any way..
> Is there an actual primary key on the server side?
Yeah.. the ID is the primary key actually.
> A CommLog file would be helpful. You can send that direct to me.
Okie.. I'm attaching one to this message..
It's the commlog of a search I've just done.
--
C'ya!
Valerio Santinelli a.k.a. TANiS
[tanis@mediacom.it]+:+[http://www.mediacom.it/~tanis]
Attachments:
psqlodbc_-4100665.log (application/x-unknown-content-type-logfiletype, 556.0K) download
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: tanis@mediacom.it
Subject: Re: [Fwd: [GENERAL] Slow Searches using MSAccess and ODBC to aPostGreSQL database]
In-Reply-To: <368A1FDC.62605DB3@mediacom.it>
* 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