Fastest way to convert a binary file to SQLite database

Question

I've some binary files and I'm looking for a way to convert each of those files to a SQLite database. I've already tried C# but the performance is too slow. I'm seeking an advice on how and what programming language should be the best to perform this kind of conversion. Though I prefer any Object Oriented Language more (like C#, Java etc), I'm open for any programming language that boosts up the conversion. I don't need a GUI frontend for the conversion, running the script/program from console is okay. Thanks in advance

Answer 1

There are lots of programming language interfaces for SQLite. The language choice will not be your bottleneck. SQLite is slow when dealing with inserting large numbers of records. It doesn't support multiple records per INSERT statement, so the best method is just to wrap the whole thing in an SQL Transaction, running lots of individual INSERT statements.

For this sort of thing, I'd suggest using ruby: sqlite-ruby gem, but really, whatever language you'd like would work just fine.