It means that people needs me to write any transaction (success, fail, or error) to a flat file.Īfter my application’s been launching live, the “operation people” can check the log file for any transaction activities using unix command : One of the important is that I have to take care of every logging activities. Thanks very much.Įntering a new coding environment (working in a national company), I’ve got several things learned. It means that sqlite run 80x longer than mysql did (very contrast with the one I read in ). When I run those 2 script, the first one (sqlite) run for 43.4918169975 seconds, while the second (mysql) only take 0.52137298584 seconds. Sqlite_exec($db, "PRAGMA synchronous = OFF ") $db = sqlite_open('pegawai.db', 0666, $sqliteerror) But, when I perform a little testing to compare them in PHP, I got a contrast result.ĬREATE TABLE test (a varchar(20) PRIMARY KEY, b varchar(20), c varchar(20), d varchar(20), e varchar(20), f varchar(20), g varchar(20), h varchar(20), i varchar(20), j varchar(20))įor that table, I perform 5000 insert for both sqlite and mysql : Lately, I read in, that sqlite is a bit faster than mysql and postgreSQL. I got double perfomance than MySQL with this (1000 insertion, Mysql took 0.1 second, and sqlite 0.05 second) Edited: Thanks to “no one” for comment on transaction mode INSERTION, with BEGIN IMMEDIATE-COMMIT pair that wrap INSERT QUERY.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |