>In my project startup code, I have set optimize ON but in my forms datenevironment, it seems to fall to OFF. I put set optimize on into the beforeopentable method and it is faster.
>Is it a normal situation ?
Hi, Eric.
Set Optimize is NOT scoped to the datasessions. Is a global SET. Check if there is anything changing it in your code.
You can use the debugger to find out where SET("OPTI") changes.
Hope this helps.