>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??
If you are running provate datasessions, you must specify the deleted setting in the init or beforeopentables of the DE. It sounds like possibly you have set deleted on in the DE, and off in the default DS.
Erik Moore
Clientelligence