Firebird or NexusDB

Question

I know that there are many Delphi database related questions available, but I'm considering only these two databases. I will need to query around 100.000 records.

From your experience which one is faster:

• as embedded
• as C/S

Thanks.

Answer 1

I Haven't used Nexus tbh, but I use Firebird regulary (Client/Server) and I am absolutely loving it. It's small, fast, tries-to-be SQL92 compliant, and the management tools are f-a-n-t-a-s-t-i-c (see IBExpert, they have free edition aswell)

The embedded version should be as good as the normal one.

Answer 2

For embedded DB SQLite would be my choice. It's fast, almost SQL-92 compatible, cross platform and free.