Devart Forums

I´m using TOraSQL.Execute(Iters: Integer) procedure to insert 250 records at once. Each record has 109 fields (Integer, DateTime and VarChar). The problem is it´s consuming almost 100MB of memory on the client machine. Is this OK? Can anyone tell me how this method works or why it´s using so much memory? Unfortunatelly, i don´t have the source of ODAC.

Thanks.

The main cause of the memory consuming is in not optimized memory allocation for Varchar params, we will optimize it in the next builds. Now you can resolve this problem by specifying TOraParam.Size property for each parameter of the Varchar (String) type.

Thank you Paul,

It worked. Now it´s consuming less than 1MB of memory.
I have another question: We have the license for ODAC 5.10 net (without source). It´s possible to get these new builds with the same license? Are these builds like fixes or they are new products?

Thank you again.

Dear Leonardo Mattos e Pinto,

Registered users of ODAC 5 will get free upgrade to further 5.xx versions.

Core Lab team