Hello FPC-Pascal, Tuesday, December 22, 2009, 1:46:33 PM, you wrote:
>> 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". MVC> About the "sqlite is faster": MVC> This depends highly on the kind of queries you are using. MVC> In my tests, sqlite was significantly slower than firebird. I compared MVC> speeds of 4 different embedded engines, and sqlite was definitely not MVC> the fastest one. SQLite is faster in "simple" queries and in exchange with used memory etc. For serious projects with important data it has many deficiences. MVC> Secondly, I would never recommend sqlite for use with Pascal applications, MVC> since sqlite does not even enforce the data to be of the correct type, which MVC> creates problems if a field of type INT contains e.g. textual data, causing MVC> a pascal application to crash. MVC> (last time I checked, they called this "a feature") Yes :) As far as I know, everything is a "text" field. -- Best regards, JoshyFun _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal