revDAVE wrote:
Hi Folks,
I¹m curious if there are any previous discussions / Articles / URL¹s that
compare the power and scalability of MySQL (with php) with other
technologies like MS sequel server oracle - coldfusion etc....
I imagine that most middleware like php / asp / coldfusion is relatively
good & fast - (let me know if one is better ). Mostly I¹m concerned with
the speed and power of the backend database as to how it functions on an
enterprise scale such as how many hits it can handle per hour how many
users before it starts to slow down etc.
honestly, if you're thinking enterprise scale then database is the least
of you're worries, you'll be needing to move away from a scripting
language and go for a pre compiled programming language.
if you must script this then mysql cluster is probably you're best route
to gain what you need, any of the others and you're (probably) going to
run into transactional problems especially with multi-master replication.
Primarily though one would imagine you'll be doing more reads than
writes, in which case you'll be needing a lot of caching in there,
second level not just the sql query cache.
Using PHP and suchlike is possible for an enterprise ap, but only if you
bolt on massive amounts of caching at both the data side and the
presentation side of your app.
Back to specifics, how the back end database will bear up in an
enterprise situation (you'll like this)
assuming that all your tables are properly created and optimised
assuming you've indexed everything perfectly after analysing every sql query
assuming you've optimised every sql query perfectly and you're database
is normalised and optimised for you're application structure
assuming you've configured all the database server variables correctly
for the application and to make the most of the hardware
assuming the physical server is of a decent specification and not an old
pentium 3 with 128mb ram
assuming you're application is well optimised and with no caches
then:
you'll find 1 database server will support approx 2 UI (user interface)
servers of a similar running at full tilt - but you've got a single
point of failure by only having one db server so you'll need to look at
that :p
all in all, with a web app that's scripted you need not worry about
which database server to use, pick one from preference and to budget and
roll with it.
IMHO go php mysql, tonnes of reference online, loads of help, cheaper
than going m$sql with windows hosting, and easier to dive in to and use
well than postgres.
ps: when you've covered all those "assuming(s)" above come back and
we'll give you a better idea of where to go next based on the info you
give us.
Regards :)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
