Filter on query of linked tables

  • Thread starter Thread starter Sunny
  • Start date Start date
S

Sunny

I am using linked tables in my application. My tables are stored on SQL
server and linked into my application through ODBC connection. I have
created one query(myQuery) on my linked tables.

On one form I have listbox and I use the following code:

lstClients.RowSource = "Select * From MyQuery WHERE myCondition"

This gives me very slow response.

Question is, This statement pulls all the data from SQL server and then
filters or it pulls the final result?

Thanks.
 
Sunny said:
I am using linked tables in my application. My tables are stored on SQL
server and linked into my application through ODBC connection. I have
created one query(myQuery) on my linked tables.

On one form I have listbox and I use the following code:

lstClients.RowSource = "Select * From MyQuery WHERE myCondition"

This gives me very slow response.

Question is, This statement pulls all the data from SQL server and then
filters or it pulls the final result?

Thanks.
Click to expand...

Impossible to say from this information. Use the SQL Profiler to see what
SQL is actually arriving at the server. Check that the columns relevant to
myCondition are properly indexed.
 
Back
Top