Recent content by tbrh66

Okay thank you. Thats what I actually doing now. I was just wondering why string variables need so much memory and other variables do not.

The variables in the query are set like this (each column of the csv file gets one variable): with OracleQuery do begin SQL.Text := MyQuery; DeleteVariables; for Column in Columns do begin with Column do begin // Float if DataType = ftFloat then...

Hello to all! I am using Array DML to insert large csv files in my database. My testfile has 50000 lines. After creating the variant arrays for each column the memory usage of the whole program is around 100mb. Than I declare and set the variables in the TOracleQuery. With types otFloat and...