Re: database (now 'MySQL/PHP')

>>Looks like I'll be in WAAAAAAY over my head with this project. I
>>suppose that I'll start with learning HTML. Then I'll do PHP followed
>>by SQLite. Then I'll end it all with Apache. Then I'll look for
>>someone to be my partner. You know... maybe I could do it via email?
>
>
> SQLite is a nice product, but I don't think it was intended to the back in
> to an eCommerce site or a database driven web site. I believe it was more
> a SQL compliant replacement to local file databases like dbf, paradox, ms
> access and the likes.
>
> I would really only recommend it for shrink wrap type single user
> applications. For example, it would make a nice backend to something like
> GNUCash or a contact manager like ACT.
>
> This is of course my opinion.

And fairly accurate. Since SQLite does database level locking, only one thread
at a time can be making any kind of changes. This isn't good for a multi-user
database needed for ecommerce as you might have 5 different threads trying to
add things to your order tables. This is why most full SQL dbs do row level
locking. Only one thread can modify any one specific row at a time, but lots of
threads can modify different rows at the same time.

SQLite sounds like a good app for a single-user stand-alone app that needs a
small footprint. Like say an app I like to use (GPSdrive) on an iPaq as only
that one app run by that one user needs to access the db to select or change things.

MySQL is used more often than Postgres because of the speed of its select
statements. I've run both Postgres and MySQL for certain apps and the
performance of both degraded dramatically as the db size increased, yet MySQL
continued to perform faster than Postgres. These db's were for the Snort
backend and were literally recording a million traps every few hours. ACID was
basically becoming a useless app to get at the data since selects were starting
to get up to 30 minutes per and the average page had at least 4 :(

My only solution for this was to rotate the data out every week and start with a
clean db and go through the databases after the fact to continue tuning Snort's
rules.
---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss