TOraSQL.Execute

Leonardo Mattos e Pinto · Post by **Leonardo Mattos e Pinto** » Mon 13 Dec 2004 19:03

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.

Paul · Post by **Paul** » Wed 15 Dec 2004 14:17

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.

Leonardo Mattos e Pinto · Post by **Leonardo Mattos e Pinto** » Mon 20 Dec 2004 13:46

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.

Devart · Post by **Devart** » Tue 21 Dec 2004 08:24

Dear Leonardo Mattos e Pinto,

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

Core Lab team