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
|
|||
|
|||
find command sql slow
any way to speed up the Find function when a form is bound to a query and
using ms sql server backend. indexing and sorting do not help. it is hanging up. tia, mcnewsxp |
#2
|
|||
|
|||
find command sql slow
On Fri, 6 Feb 2009 13:11:12 -0500, "mcnewsxp" wrote:
any way to speed up the Find function when a form is bound to a query and using ms sql server backend. indexing and sorting do not help. it is hanging up. tia, mcnewsxp Care to give us some hints about the nature of the query or the code? Generally one would create a highly selective query retrieving just a single record, or a small number of records, and pass that Query to SQL, rather than binding the form to a large table and then using the Find function. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
find command sql slow
On Feb 6, 4:52*pm, John W. Vinson
wrote: On Fri, 6 Feb 2009 13:11:12 -0500, "mcnewsxp" wrote: any way to speed up the Find function when a form is bound to a query and using ms sql server backend. *indexing and sorting do not help. *it is hanging up. tia, mcnewsxp Care to give us some hints about the nature of the query or the code? Generally one would create a highly selective query retrieving just a single record, or a small number of records, and pass that Query to SQL, rather than binding the form to a large table and then using the Find function. -- the app was recently converted to using linked sql tables. all forms use what ever data source they had before the conversion. the form in question is bound to a query that contains 3 tables. if we have to redesign we will. just wondering if there was some known trick to make the Find function speed up. |
Thread Tools | |
Display Modes | |
|
|