Thanks for that, while most of the findings there are the same as mine, there's still the point about indexes. And i found out in "SQLite Administrator" that, while the orderid was a primary key, there was no index on it. Maybe that's because i created it like this: "orderid INTEGER PRIMARY KEY UNIQUE NOT NULL," instead of setting it explicitly to primary in the last line of the create query.

Edit: Huh, this is weird. Neither way of creation actually creates an index... What's wrong with this query?

CREATE TABLE IF NOT EXISTS moo3 (
 orderid INTEGER PRIMARY KEY NOT NULL,
 volume INTEGER NOT NULL,
 price REAL NOT NULL
)
[download]