MS Access 97 SR-1, psqlodbc 7.01.00.06, slow perfomance

Поиск
Список
Период
Сортировка
От Jüri Fjodorov
Тема MS Access 97 SR-1, psqlodbc 7.01.00.06, slow perfomance
Дата
Msg-id 3B4B1CD4.590891FC@nowecanspam.ee
обсуждение исходный текст
Ответы Re: MS Access 97 SR-1, psqlodbc 7.01.00.06, slow perfomance  (Andrew Gould <andrewgould@yahoo.com>)
Список pgsql-general
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-general по дате отправления:

Предыдущее
От: "Jeff Rhys-Jones"
Дата:
Сообщение: RE: Inner Join?
Следующее
От: "Mark G. Franz"
Дата:
Сообщение: Re: Grab data WHERE table.ID NOT LIKE otherTable.ID