Re: [sqlite] Performance of SELECT: What am I doing wrong?

On Wednesday, Oct 26, 2011 at 02:26PM Jay A. Kreibich wrote: > On Tue, Oct 25, 2011 at 11:51:46PM +0200, Tobias Mohrlüder scratched on the > wall: >> Hello everybody, >> >> I strongly believe that my setup is somehow wrong, I just can't figure >> out how. > >

[sqlite] Performance of SELECT: What am I doing wrong?

Hello everybody, I'm currently experimenting with SQLite (3.7.8) and am a complete newbie in the field of SQL databases. Running performance comparisons between a C++ std::map< int, std::string > and an in-memory SQLite database, I found SQLite to be astonishingly slow when selecting single