Hi,

 

i work with big csv files and to speed up operations i convert it do external table format with my tool.

It convert all fields types and work fast

but may be in Firebird 3 are some improvements?

Maybe this step is now unnecessary? 

 

Can we separate csv file on the fly in FB proc? and loop throught?

Or are some improvements like mulit insert statement

Insert into XXX

VALUES(aaaa),

VALUES(bbbb),

VALUES(CCC)

 

or something like this ore other way?

If exists - what are the limits about statement count, length etc.?

 

regards,

Karol Bieniaszewski