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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filter on query of linked tables
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. |
#2
|
|||
|
|||
"Sunny" wrote in message
... 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. 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Complex Query (was: Refresh vs. requery vs. Remove Filter in FormsCoding NG) | rgrantz | Running & Setting Up Queries | 1 | November 23rd, 2004 01:59 AM |
Unmatched Query Mess | Natalia | Running & Setting Up Queries | 8 | October 28th, 2004 02:36 PM |
Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
Delete Query | Shanin | Running & Setting Up Queries | 14 | July 31st, 2004 07:15 PM |
Union query with filter - different results on different computers | Nick | General Discussion | 4 | July 18th, 2004 05:20 AM |