Question: What are the differences between [SQLite](http://www.sqlite.org/) and [DISQLite](http://www.yunqa.de/delphi/doku.php/products/sqlite3/index) and why would I want to pick one over the other?

My context is that I am dealing with a large database (could be up to 10 GB), the critical part of which is in one very simple table with a single indexed field and one text field up to a few KB in size. My development tool is Delphi 2009 and the database will be embedded in my .exe.

My main criteria is speed. This would be for a software application running on a typical Windows computer, say with Windows 7 and 4 GB of RAM.

If you want to suggest another database tool, please tell me why it would be better than these two for my application, especially on the speed frontier.

Answer: 
I can suggest you writing your own implementation. If you don't need complex SQL queries, the simplest (and probably the fastest) implementation is file-based storage.
Note that the DISQLLite personal version has some limitations and I don't think that the price for the professional version (Euro 149.99 without source) is worth it when anyone can just implement a SQLite wrapper for free. 

I was using DISQLite personal for a freeware product and had to implement a database change in a new version release. The personal version does not support 'ALTER' so I was faced with having to purchase the full version. So I ditched DISQLite and just went with a good SQLite wrapper. Only go for DISQLite if you're prepared to pay for the full version.

[SQLite4Delphi](http://sqlite4delphi.sourceforge.net/) might be a better option, or at least point you to a more cost-effective solution.