>Hello,
>
>We have noticed our database server has suddenly become extremely slow with all client applications except for Enterprise Manager. When we run a simple SELECT statement such as 'SELECT * FROM customers' in Query Analyzer the query takes over 2 minutes. But if we run the exact query in Enterprise Manager the results come back immediately. The same database server is being used to drive our web apps, which are written in Cold Fusion. The web apps are also running extremely slow.
>
>Does anyone have any thoughts on this?
>
>TIA,
George,
Just a SWAG, I'd guess at that the dataset you're trying to retrieve has grown larger than originally anticipated. If so, then there are two possible solutions. This is assuming that VFP is the tool.
1. Reduce the size of the data set by making the filter condition more restrictive.
2. Issue a GOTO BOTTOM command (assuming a remote view) immediately after the USE.
George
Ubi caritas et amor, deus ibi est