synapsevampire
Programmer
The new DBA here recently reconstructed a database, and after doing so, our performance has tanked, so much so that the VFP developers are placing inkey(3)'s (wait 3 seconds) into their code to allow for the database.
The SQL Trace doesn't show any errors, we've tried the database on multiple servers and clients on different desktops, all with the same results.
It appears that the connection handle is getting crushed, the only indicator being a cryptic VFP error that the connection is busy, though the trace shows that it's completed the last query.
Any thoughts, and how might I verify connection handles?
-k
The SQL Trace doesn't show any errors, we've tried the database on multiple servers and clients on different desktops, all with the same results.
It appears that the connection handle is getting crushed, the only indicator being a cryptic VFP error that the connection is busy, though the trace shows that it's completed the last query.
Any thoughts, and how might I verify connection handles?
-k