Timer Control and App Performance

[emeryp]

Hi Everyone,
I have a timer control that uses ADO to retrieve data. The problem is that there is a visible delay in the application. I have placed 'DoEvents' in the code and have seen an increase in performance but would like to know if there is something I'm overlooking?
Thanks

 

[CCLINT]

Don't use a time control.
Use the Async option in the options parameter of the ADO recordset Open Method:

rs.Open Options:=adCmdText Or adAsyncFetch

[/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[emeryp]

How does the AsyncFetch option work and how do I invoke it. Currently, I am using the ADODC and do not see an option for fetch or async. I just query and refresh the ado. Are you asking me to pull a static view of the table and use an async function to keep it refreshed?

 

[CCLINT]

Uh, are you using a timer to refresh the data on a continuous basis???? [/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[emeryp]

Yes. Because I have more than one query being sent to the database at a time.