SQL Queries with ODBC

[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.

 

[Ron Weiner]

I am totaly unfamiliar with Postgres, nut I suspect that unless you are
using a "PassThru" Query you are probably creating lots of network traffic.
The most efficent way to query the database would be to create Stored Procs,
UDF's, and Views in Postgres (assuming Postgres supports them) and execute
them from access, or use "PassThru" Queries from Access. This way only the
rows the app needs are moved over the network.

In pratice however you should do some testing to see how much the additional
network traffic affects performance. If I had a million row table and I
only needed one record, I would attempt to do as much Server Side stuff as I
could.

Ron W

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?