CODEWITHSUNDEEP
c++sqldatabaseperformancesqlite
Richard Fabian
Richard Fabian

Reputation: 697

Even lighter than SQLite

I've been looking for a C++ SQL library implementation that is simple to hook in like SQLite, but faster and smaller. My projects are in games development and there's definitely a cutoff point between needing to pass the ACID test and wanting some extreme performance. I'm willing to move away from SQL string style queries, allowing it to be code driven, but I haven't found anything out there that provides SQL-like flexibility while also preferring performance over the ACID test.

I don't want to go re-inventing the wheel, and the idea of implementing an SQL library on my own is quite daunting, even if it's only going to be a simple subset of all the calls you could make.

I need the basic commands (SELECT, MODIFY, DELETE, INSERT, with JOIN, and WHERE), not data operations (like sorting, min, max, count) and don't need the database to be atomic, or even enforce consistency (I can use a real SQL service while I'm testing and debugging).

Upvotes: 9

Views: 1958

Answers (6)

Tristram Gräbener
Tristram Gräbener

Reputation: 9721

I'm not sure you'll manage to find anything with better performances than SQL. Especially if you want operations like JOINs... Is SQLite speed really a problem? For simple requests it's usually faster than any full SGDB. Don't you have an index problem?

About size, it's not event 1Meg extra in the binary file, so I'm a bit suprised it's a problem.

You can look at Berkeley DB which has to be probably the fastest DB available, but it's mostly only key->value database.

If you really need higher speed consider loading the whole database in memory (using SQLite again).

Upvotes: 10

ravenspoint
ravenspoint

Reputation: 20596

Are you sure that you have obtained the maximum speed available from SQLITE? Out of the box, SQLITE is extremely safe, but quite slow. If you know what you are doing, and are willing to risk db corruption on a disk crash, then there are several optimizations you can do that provide spectacular speed improvements.

In particular:

  • Switch off synchronization
  • Group writes into transactions
  • Index tables
  • Use database in memory

If you have not explored all of these, then you are likely running many times slower than you might.

Upvotes: 14

Kokizzu
Kokizzu

Reputation: 26898

you can try leveldb, it's key/value store

http://code.google.com/p/leveldb

Upvotes: 0

MSalters
MSalters

Reputation: 180235

You might want to consider Embedded innoDB. It offers the basic SQL functionality (obviously, see MySQL) but doesn't offer the actual SQL syntax (as that's part of MySQL, not innoDB). At 838KB, it's not too heavy.

Upvotes: 1

zvrba
zvrba

Reputation: 24584

Take a look at gigabase and its twin fastdb.

Upvotes: 1

Roman Bataev
Roman Bataev

Reputation: 9361

If you just need those basic operations, you don't really need SQL. Take a look at NoSQL data storage, for example Tokyo Cabinet.

Upvotes: 0

Related Questions