Обсуждение: [Fwd: [GENERAL] Slow Searches using MSAccess and ODBC to aPostGreSQL database]
[Fwd: [GENERAL] Slow Searches using MSAccess and ODBC to aPostGreSQL database]
От
Valerio Santinelli
Дата:
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]