[sqlite] [PHP5] Direct access to SQLite faster than through PDO+APC?

[Gilles Ganault]

Hello

        I wanted to check performance in PHP through caching tools like APC
or MemCacheD compared to direct access trough PDO_SQLite, and it seems
like APC is actually five times slower than accessing an SQLite
database directly:

=======
# ab -kc 10 -t 30 http://localhost/test_apc.php

Percentage of the requests served within a certain time (ms)
  50%    105
  66%   1054
  75%   2066
  80%   3089
  90%   4347
  95%   8136
  98%  10140
  99%  12148
 100%  13115 (longest request)
========
# ab -kc 10 -t 30 http://192.168.0.2/test_direct.php

Percentage of the requests served within a certain time (ms)
  50%     29
  66%     30
  75%     31
  80%     32
  90%   2038
  95%   6072
  98%  14049
  99%  17056
 100%  17199 (longest request)
========

Does APC start making sense with a lot more users, or is SQLite just
much faster than MySQL?

Thank you.

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users