>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.