Sleep vs Timerinterval
Posted on 2011-03-02
Which is better (or are they the same) Sleep or Timerinterval? I have a form where onCurrent I need to establish some variables, count the # of days based on a couple dates, and a couple of other calculations.
I also have code behind the column headings (on a continuous form) to sort the contents of the column --
if me.orderby="FieldName" then me.orderby="FieldName DESC" else me.orderby = "FieldName"
The onCurrent bogs down the sort -- so I put the culprit code in a timer -- but it still seems that things keep running too slowly.
I have tried Application Echo and the DBEngine.Idle dbRefreshCashe ---
Nothing seems to work.
This is not a large db. It's a FE/BE (.accdb) with about 8 users consecutively. The BE never grows beyond 30mb.
The form is bound because it requires real-time updates available to all the users.
Any suggestions that would help me speed things up would be appreciated.
Thanks a lot!!