[sqlite] SQLite with PHP and Apache C Module

[Sam Carleton]

My web application is a mix of PHP code and an Apache C Module.  Both
access the same SQLite3 database.  Because of this, I am using the
shared version of the PHP SQLite library and the Apache C module is
dynamically linking, as well.  The Apache C module only connects to
the database during an admin request, which does not happen all that
much, normally the Apache C module is checking access and serving up
images.

One of my customers is experiencing a major performance problems.  I
am running on a Pentium IV 2.8 GHz machine and it can serve up 12
images real fast, my customer has a Duo Core 1.8GHz machine and it is
taking 45 seconds!  I am thinking that maybe it is the SQLite code
that is causing problems.  Once I open the database in the Apache C
Module, should I keep it open for the life of Apache?  I am not right
now, I open and close for every query.  Is there anything special I
should be doing in PHP to optimize the performance?

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

[sqlite] SQLite with PHP

[Cesar D. Rodas]

Hello,

This message is only for let know users that I've wrote a class for manage
SQL database using the same interface.

It supports:
- Connect to a database given a connection string
- Prepared queries
- Caching query results in files
- Binding variables to query result columns
- Fetch whole result sets into an array

SQLite is supported but not well tested :-$, for a matter of time. It will
be great if the SQLite people could test this class and let me know if there
is a bug or for request new features.

http://cesars.users.phpclasses.org/browse/package/4222.html, here is the
class site.

-- 
Best Regards

Cesar D. Rodas
www.cesarodas.com
www.thyphp.com
Phone: +595-961-974165