>>I have a parameterized view in my form's DataEnvironment that's taking 10 seconds to create in the dodefault() of OpenTables.
>>
>>When I reboot (to clear the cache) and run the exact same SQL statement at the command window, it takes < 1 second.
>>
>>Any Ideas??
>Darren,
>
>Yes, there are no indexes on DELETED() and the form is using set deleted on while the command window has set deleted off.
Thanks for your help, Jim, but I realize now that my assumptions were wrong. It turns out that the view is 10 times slower when it includes a calculated field.
I had << trim(firstname)+" "+lastname as fullname >> in my view; I suppose now I'll have to add the fullname field into my base table and use field-level validation in the .DBC to maintain it.
Darren Young