On Tue, 22 Dec 2009, JoshyFun wrote:
Hello FPC-Pascal,
Tuesday, December 22, 2009, 12:55:07 AM, you wrote:
ZD> I think you talk about Firebird embedded version 1.0, SQlite3 best than it
ZD> I have Point of Sale application use Firebird 2.1 in desktop PC and
ZD> Sqlite3 in Wince, the same project with same SQL statements (with a
ZD> little directive for special queries).
SQLite is faster than Firebird, but take care that SQLite does not
enforce foreign keys, so data integrity must be handled by the
programmer "manually".
About the "sqlite is faster":
This depends highly on the kind of queries you are using.
In my tests, sqlite was significantly slower than firebird. I compared
speeds of 4 different embedded engines, and sqlite was definitely not
the fastest one.
Secondly, I would never recommend sqlite for use with Pascal applications,
since sqlite does not even enforce the data to be of the correct type, which
creates problems if a field of type INT contains e.g. textual data, causing
a pascal application to crash.
(last time I checked, they called this "a feature")
Michael.
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal
