>The key point here is that I can use MySQL on NT with ColdFusion, with
>probably just a few hours of work changing the SQL statements to jibe with
>the MySQL ODBC driver. Also, by having my data in MySQL on NT, I am probably
>only a short step away from being able to move it over to a Unix box - which
>I will probably do, depending on my scaling needs and schedule, when a
>native version of CF comes out for HPUX or Linux *or* when/if I decide to
>port to PHP.
sounds like a sensible way to go about it, IMHO. it certainly shows
willing on your part, which gives you some counter-thwocking power if the
system types still feel like digging their heels in.
eliminating inner joins can be a bit of a pain.. usually it involves more
data handling or storing at the query end. the good news is that it's
unlikely you'll need to redefine the tables themselves.
>If anyone has any experience running MySQL in a high-demand, busy
>environment, I would be interested in hearing from them.
Charles, the PHP guru, is also something of a MySQL fanatic. he was quite
pleased with its performance under high load conditions.
just to make your life slightly more difficult, you might also want to
check out postgresql.. i believe it comes as part of the default
installation of Red Hat. it's compatible with PHP, and offers a fairly
wide range of APIs and tools:
http://www.postgresql.org/
granted, this isn't likely to be an immediate contender if you want to stay
on NT/CF long enough to get things rolling. it's primarily unix based,
but has the advantage of being free. one more thing more to look at, at
any rate.
off the top of my head, i don't recall if postgresql supports inner joins
or not. i know it supports some object-oriented features like
inheritance, and that can be used in ways similar to a join. probably not
a range of technology you're interested in learning just right now, but
it's worth considering for your long-term plans.
mike stone <[EMAIL PROTECTED]> 'net geek..
been there, done that, have network, will travel.
____________________________________________________________________
--------------------------------------------------------------------
Join The NEW Web Consultants Association FORUMS and CHAT:
Register Today at: http://just4u.com/forums/
Web Consultants Web Site : http://just4u.com/webconsultants
Give the Gift of Life This Year...
Just4U Stop Smoking Support forum - helping smokers for
over three years-tell a friend: http://just4u.com/forums/
To get 500 Banner Ads for FREE
go to http://www.linkbuddies.com/start.go?id=111261
---------------------------------------------------------------------
