I have an application using an SQL Server DB for it's data.
Simply put, I can run the code pointing to a local SQL Server(2008). Performance SUCKS BALLS. One particular move function takes about 22 seconds to return.
Same code, same function, with the ONLY change being to the underlying ODBC connection to a remote machine running the same version of SQL server, configured essentially the same (they're both development machines with copies of client DB's, with the same OS ad hardware..), the same function using the same DB(remote) completes in about 2.5 seconds.
Any ideas? I've already tried different combinations of Shared Memory/Named Pipes/TCP-IP along with restarts of the services and modifications of the ODBC settings accordingly.
XP SP3/ Intel P4 3.2 gHz 3GB RAM w / PAE