i stopped playing around with sqlite. why? because it sucks or im doing something really wrong.
20 minutes ago i started using the maxmind db for geotargeting. i got 140ms per request with sqlite, same after i moved it into the shared ram. guess how fast it is with mysql… 0.025 milliseconds or 25 microseconds - for mysql_query() -> return $array. that means mysql is 5600 times faster.

the guys in #sqlite on freenode.net tryed to tell me its because im using lighttpd with php-fcgi and thats why its so slow and i should better change to apache with mod_php.

yeah, exactly.