Some philosophical observations:
My personal opinion would be to stick to a unix environment (Sun, Linux,
FreeBSD...) and hold on to the Oracle part. I find that JSP is a bit
cumbersome to maintain and program.
An alternative to Oracle would be Postgres/SQL as they handle transactions
relatively similarly. There was an article in Webtechniques which described
the general security of using Postgres instead of MySQL when you can't
afford Oracle. So you should check into that since you'll be handling
sensitive information which can't get lost if someone unplugs the server or
there's a power failure, or some other general disaster. The point being,
the article explained how Postgres can handle data recovery (something stops
in the middle of a process) while with MySQL, I wouldn't be so sure.
(Personally, I love MySQL... because its so easy to use, but I wouldn't rely
on it when it comes to sensitive stuff like keeping track of purchased
goods... I could be wrong. Although I do use it for relatively indifferent
needs! Subscriptions other traditional database stuff.).
As far as Windows goes, great to play with but I wouldn't trust it with my
life. Something to think about: basic security on Windows is a a hassle. The
OS doesn't behave well when you create .htaccess files (just one example),
I've been able to get past these quite easily using Windows. This on the
otherhand is quite straight forward in unix. And if you forget Windows, you
can then forget about the general head-ache of configuring PHP with IIS and
the SQL server that exists.
Consider hiring a professional unix system manager, someone with Linux or
FreeBSD experience perhaps...
Hope this helps.
Dan McCullough [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
If everyone could gather around for a minute or two. We are looking at
switching from a
propriatary JSP/JS/Java based system and going to PHP as our ecommerce
system. We currently have
Oracle db and hosted on Sun equiptment, which we are in for another 3
years, although upgrades are
planned. We hate the current system, it was picked for us in a closed
room environment. We have
been looking to get off ever since we launched, actually even before we
launched. I have been
developing in PHP before I got this job and advised against the vendor
that we had, now I want to
develop my own system. This is the backend systems we have. One system
that I'm not to sure of
is MQ Series, can PHP tie into that, or would we have to work around that,
MQ messages back and
forth with our legacy system to give a real-time connection to our actual
customer and inventory
and order processing pieces, although some C++ cdode sits between that and
the JS layer. Another
concern is how well does Sun and PHP get along, we have these nice boxes
that is actually
handleing the memory hog that we have now, and I know that we couldnt just
dump the servers.
Anyone have an idea on a site that processes between 150-250 orders and
averages $65k a day, if
PHP and MySQL can handle that, or would I have to go to something like
MSSQL (I know I know MS and
PHP .. hahahahahaha). All and any suggestions are welcome.
dan mccullough
web technology
603.823.5545 x 1119
There is no such thing as a problem, unless the servers are on fire.
Sometimes great opportunity comes brilliantly disguised as bad news.
__
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
