If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: slow read when using MoveNext with ODBC

I have an application that's been developed in MS Access, that's being accessed over the network. I'm considering to migrate the database to pgSQL and use it as back-end, and MSAccess as front-end, connecting them over ODBC.

When timing different operations, I found out that using the moveNext together with reads seriously drops performance, making the whole setup totally useless. Here's an output from the timings:

I've been searching forums etc. for a cpl days straight without finding anything helpful. I think the problem lies somewhere between my vba code and the odbc driver. It shouldn't be anything wrong with pgSQL itself since the same problem shows for MySQL, and I don't think the problem should be in the ODBC driver since other operations (like testDMin with a lot of reads) works even better than native Access.

Does anyone have a suggestion of how to fix this problem?
I would really appriciate if someone could help out!