Hi,
Last time i tried embedded mysql (4.1) i just noticed it was buggy and
not properly documented. i could get it to work but is still needed
silly things like a my.cnf on the c:\ drive (windows), possibly
conflicting with a running mysql server.
To me it looks embedded mysql needs tonloads of work, has issues when
distributing your app etc, where sqlite works just fine, and has
potentional te be faster as well.
Did not do any benchmarks, but it appears to me that performance of
embedded mysql is comparable to running a mysql server on localhost.
Also be aware that in case your application crashes for whatever reason,
embedded mysql crashes as well and thereby your database files are very
likely to become corrupted...
regards,
rene
Rajan, Vivek K wrote:
Has anyone done comparison between embedded mySQL and SQLite? Would like
to request feedback/comments on how do the two technologies
contrast/compare?
Vivek