I have to insert more than 2000 records at a time with blob fields in the Interbase database. There is a performance issue if we execute query for every insert.
I found out that batch insert is the solution. But, I have to prepare all the queries first to run insert queries' scripts. My question is, how to prepare the queries' scripts with blob fields?
Please suggest me if there is another solution to improve the performance.