Network efficiency in queries

[wheeel_o]

I am using a Postgres backend and Access for my frontend.

When I run a query in access, does the entire table which i am querying get transferred over the network and then get sorted by Access or does the ODBC create a Postgres SELECT command and transfer the output of that SELECT over the network?

To make my queries the most network efficient, should I be using queries in access? Views in Postgres? or maybe VB in Access?

Thanks very much.

 

[Van T. Dinh]

Sort of in-between the 2 scenarios you described. The ODBC creates an
ODBC-compliant SQL (not Postgres SQL) and use this to retrieve the data.
AFAIK, Access / the ODBC-compliant SQL generally only retrieves "enough"
data to fill the "crenn" and a bit extra. I have been using ODBC-linked
Tables from SQL Server with some very large Tables and I am sure that the
ODBC-compliant SQLs do not pull the whole dataset through the network.

Views are probably more efficient since the processing is done on the
server, not the client.

--
HTH
Van T. Dinh
MVP (Access)

I am using a Postgres backend and Access for my frontend.

When I run a query in access, does the entire table which i am querying

get transferred over the network and then get sorted by Access or does the
ODBC create a Postgres SELECT command and transfer the output of that SELECT
over the network?

To make my queries the most network efficient, should I be using queries

in access? Views in Postgres? or maybe VB in Access?