The first thing you have to do is isolate exactly what is slow. If it's a query you're sending to the server, make sure you have sufficient indexes. You especially want an index on whatever field can narrow down the search the most as SQL Server will only use one index. Make sure you're running UPDATE STATISTICS frequently on the server. This is especially important if you're adding a lot of records. Of course, you should try to make your queries return as few records and fields as possible. If the delay is due to the complexity of the query, more server RAM and processing power will help. If it's happening when the result set is returned, try to beef up your network.

>Thanks for the reply! We have an app that is using SPT and it still seems slow. I suspect it is the network setup. Do you have any recommendations on how to speed up the app?