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]