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:
Thanks.
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.