News Feed
Jobs Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Windows Skills Blog:
Using SQLite as a database backend for a lightweight server
February 07, 2007 @ 09:10:00

On the Windows Skills blog, there's a new post that talks about the use of a SQLite database (via PHP) to handle the assault that Digg.com can dish out to a popular webiste.

Physical memory was limited and Apache and MySQL soon started to fight for every remaining byte and eventually the page was unavailable. After this experience I started to look for a alternative for the database storage and I found an interesting one: SQLite.

He mentions some of the features the database has including zero-configuration, a simple API, and the portability of having a single database in a single file. The next step was getting it to work with his Apache/PHP5 installation and to run some statistics on it. The results show SQLite pulling ahead of MySQL (INNODB) by a bit and MySQL (MYISAM) by a good bit.

0 comments voice your opinion now!
sqlite windows database php5 benchmark statistic graph sqlite windows database php5 benchmark statistic graph


blog comments powered by Disqus

Similar Posts

Stefan Priebsch's Blog: PHPUnit test and Code Coverage Statistics with phing

Dotvoid.com: PHP 5.2 ajaxified

Elizabeth Smith's Blog: How to Compile PHP5.2 and PHP-GTK2 on Windows using Visual C++ Express

NetTuts.com: Learn to Create Interactive Drill-Down Dashboards with PHP and FusionCharts

Edin Kadribasic's Blog: Back to VC6 for PHP Windows build


Community Events











Don't see your event here?
Let us know!


release symfony2 hhvm language package opinion install component facebook unittest composer security podcast code example hack application introduction overview framework

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework