On Tuesday, July 1, 2003, at 03:49 PM, Sterling Hughes wrote:
You can't look at raw performance on a simple script in terms of req/s, but rather percentages. Most scripts are complex, and will have plenty of other logic in them. Having a 1/3 performance decrement can add up.
This is a completely bogus argument.
a) a 1/3rd slowdown under high load does not imply a 1/3rd slowdown under low load - in fact your whole argument is that sqlite suffers from lock contetnion problems which only manifest under high load.
b) a 1/3rd slowdown in a 3 line test does not work out to a 1/3rd slowdown on a larger application. Your script was tight enough to closely reflect the slowdown of using sqlite versus files. In longer running scripts this overhead is propogated as a constant, not linearly.
George
-- PHP Internals - PHP Runtime Development Mailing List To unsubscribe, visit: http://www.php.net/unsub.php
