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

PgSQL vs Ms.Access slow in search

From: Alejandro Alfonso Fernandez <kawa(at)enete(dot)gui(dot)uva(dot)es>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: PgSQL vs Ms.Access slow in search
Date: 2001-10-10 10:00:02
Message-ID: Pine.LNX.4.33.0110101134100.29039-100000@enete.gui.uva.es (view raw or flat)
Thread:
Lists: pgsql-odbc
Hello everybody!

	First of all, sorry for my poor english. And now, the problem
that don't leave me sleep :). I'm using PgSQL as the data source of some
forms in MsAccess, with the current version of the ODBC driver. It
exports/imports tables right and fast. But... when I have the tables
"linked" (it's correct this word???), and i try to do a search (Edit->Find
or Ctrl-B) in any column of any table with more of 1.000 tuples:
 first: the access seems to be dead thinking too much :)
 second: the postmaster takes 99% of CPU
Why????? In numerics primary keys, the both works better, but most of
time, they dead.

I've startde postmaster from a shell, and I get:
2001-10-09 20:39:50 [6573]   DEBUG:  StartTransactionCommand
2001-10-09 20:39:51 [6573]   DEBUG:  CommitTransactionCommand
2001-10-09 20:39:51 [6573]   DEBUG:  StartTransactionCommand
2001-10-09 20:39:51 [6573]   DEBUG:  CommitTransactionCommand
2001-10-09 20:39:51 [6573]   DEBUG:  StartTransactionCommand
2001-10-09 20:39:51 [6573]   DEBUG:  CommitTransactionCommand
2001-10-09 20:39:51 [6573]   DEBUG:  StartTransactionCommand
2001-10-09 20:39:51 [6573]   DEBUG:  CommitTransactionCommand
2001-10-09 20:39:51 [6573]   DEBUG:  StartTransactionCommand
2001-10-09 20:39:52 [6573]   DEBUG:  CommitTransactionCommand
(only 4 querys from each second?????)

I've tried to fin a solution by my self, but I couldn't :(. With MySQL ->
MyODBC -> Access the problem It's the same.

Thanks in advance from Spain...

    _____    - - - - - - - - - Alejandro Alfonso Fernández - - - - - - - - -
   /\___/\   Grupo Universitario de Informática - Diplomatura en Estadística
  /__\ _\/   - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 /_/\_\      - "Lo mejor de tu ordenador está entre tu silla y tu teclado" -
/_/ /\_\      Atari Php Asp Wap Sql Dhtml Swf JavaScript Java Xml C Awk Sed
\_\/  \_\    - Email: kawa(at)gui(dot)uva(dot)es - Web: http://www.gui.uva.es/~kawa/  -
L.Carrol:   Hace falta que corras todo lo que puedas para seguir en el mismo
sitio. Si quieres ir a alguna parte, ­tendras que correr el doble de rapido!
*gpg*public*key->http://www.gui.uva.es/%7ekawa/alexokawa.gpg<-gpg*public*key


pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2001-10-10 10:35:38
Subject: Re: SQLPutData bug ?
Previous:From: Mika MantylaDate: 2001-10-10 08:15:33
Subject: SQLPutData bug ?

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