Leaderboard

My remarks on degrading performance relate purely to the suggested replacement for the PRIMARY KEY by drjdpowell. I see similar write performance (fast, constant) when using a normal "rowid" primary key. As soon as I introduce my X,Y,Z Primary key as suggested ealier in the thread, I see significantly worse performance to the point that it rules out SQLite for the required function. I really need 20k INSERTS per second. At the moment I'm resigned to writing with standard rowid Index and then adding the X,Y,Z afterwards for future read access. Standard "rowid" Primary KeyIndex Compund (X,Y,Z) Primary Key Index

There's a reason I always gave management an estimate that was 4x what I thought it would take. They would always cut an estimate in half trying to win the bidding war and then crap happens which causes things to take twice as long as you initially thought. Hey, I was right on budget! How did that happen?