
VB App slows to crawl, also TimeOut Expired
Quote:
> Jeff
> Solution 1
> Regarding the SQL Server 4.20 issue try running a CHECKPOINT and DUMP
> TRAN
I'll try the checkpoint and killing the transaction log. Thanks.
Quote:
> Regarding the timeout error in the sub main orwhen you open your
> database increase the database query time out by typeing the following
> database.QueryTimeout = seconds
> seconds is a variable the default is 60 seconds.
> The ultimate solution
> If you are using bound controls try and get rid of them. (This will
> most certainly get rid of the lag. but requires a lot more coding.)
It already doesn't have any bounds controls. It's a screen of
dynamically allocated labels. The error occurs when the labels are moved
around on the screen (ala Solitaire). The error happens almost
immediately after dragging the label(which does a save to the SQL Server, so
I am not sure if it's the DB.Execute command that I had just issued to do a
save, or if it's from a previous command that just had timed out. Any
other hints?