>Well, THAT wasn't it, either! I have an unfiltered DELETED() index, and sys(3054,1) says that everything is optimized.
>
>Another odd thing is that using different parameters affects performance. One index returns 950 records in 1.5 seconds, while a second returns 780 records in 8 seconds (both character, regular, unfiltered, fully optimized, out of 40,000 total records).
>
>And running the equivalent SQL-SELECT from the command window is still at least 10 times faster.
>
>Is browsing a view slower because it's written to disk? And what other factors should I consider?
>
>Signed, Painfully Frustrated
Darren,

If the same sql is 10 times faster in the command window than from inside your app then we have to ask what is different between the two environments. Check on available memory, set command settings (especially set compatible which can cause all kinds of wierd stuff). Under most conditions a fully optimized query will take time relative to the number of records in the result set, that is the more records returned the longer the query takes to run. Can you post the query that is giving you these results?