[odb-users] Options to speed up object persist to sqlite3 DB?

[Justin Huang]

Hi,

I used VTune to profile my program and it showed odb::database::persist (more specifically odb::sqlite::insert_statement::execute) is the bottle neck. It takes around 3 seconds to persist 7k simple object (I am not quite sure if this is normal or not).

In my program, I iterate all objects and call db->persist(object) one by one. Are there faster ways to persist objects?

Thanks,
Justin

-----------------------------------------------------------------------------------
This email message is for the sole use of the intended recipient(s) and may contain
confidential information.  Any unauthorized review, use, disclosure or distribution
is prohibited.  If you are not the intended recipient, please contact the sender by
reply email and destroy all copies of the original message.
-----------------------------------------------------------------------------------