lol no im not picking on you Chris! :)
Just one thing to point out mySQL is in no way a
true RDBMS like Oracle, and mySQL has to be seriously
beaten with a stick to really scale.
mySQL is designed for a high number of reads low
number of writes (meaning lots of selecting little
saving of information)
It is missing veyr many key components which if
your writing an app make the "faster" question
irrelevant. Here are a few things mySQL is missing.
Foreign Keys (better code good ;)
Stored Procedures
Sub Selects
Transactions
Granular Locking (whole table must be locked)
Along with a few more minor points.
However thsoe are some major features which make
mySQL largely non ANSI-92 compliant. They are
working on being compliant but its not really what
mySQL was ever designed for. Its a very quick way
to setup a site like a web portal thats going to
regurgitate data a lot but not really deal with a
whole lot of gory things like E-commerece, sites
that deal with a lot of data saving / manipulation
etc.
You CAN get away with all of this, but for the
same price I recommend PostgreSQL which has all
of the aformentioned features and scales more than
MySQL (its not quite as quick on some things as
mySQL but then neither is Oracle) PostgreSQL
I have heard a few bad stories about but
my personal experiences (including using its
C API to hook up a C program to a database)
were all very positive. I found the documentation
Excellent, I found the database to be very solid
and configurable, and overall it has everything
you would look for in a RDBMS.
On top of that in the 4.5 Release notes it is briefly
discussed how to get PostgreSQL working over ODBC
(sorry no native drivers).
So overall if you are looking for a cheap database
that is rather feature rich, I say go with Postgres.
-----
Again, I think X with the proper video card is a dream
really, try it out again with XFree 4.01 its worth trying
as long as you dont run to much bloated stuff (Gnome, KDE)
it can be nice.
I agree Star Office tries to be everything for you and it
was rather slow and memory intensive to say the least.
Web browsers, there is Konquerer, The latest releases
of Mozilla (NOT netscape), Opera 4.0bx, Netscape 4.7
and my favorite lynx (hehe it runs in an xterm just fine!:)
I dont follow mozilla to closely, it is still to darn
buggy to be used constantly, and just to pay lip
service to what I have heard, Opera runs very nicely.
-----
Really im not picking :)
If the shoe fits wear it, if not dont try!!! :)
Same applies to programming tools and OS.
Jeremy Allen
[EMAIL PROTECTED]
-----Original Message-----
From: Chris Lott [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 12:50 PM
To: CF-Talk
Subject: Re: Which Platform is most scabable for CF 4.5?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
>I usually run my desktop machine under X (usually GNOME). I use
>Staroffice,
> > Netscape xnews etc and it is much faster than a higher spec NT box with
> the same memory (128Mb) and a larger processor.
Interesting... definitely completely the opposite of my experiences. Star
Office was very buggy and I have yet to see a decent web browser in X. But
I love Linux for other reasons, and use it all the time. Just not with X.
Maybe I'll give it another go sometime.
> I have been involved in testing a linux box running mySql & Oracle on a
> linux box and its performance is faster than NT - sometimes by a small
> amount - sometimes more.
mySql is definitely faster on Linux.
c
-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8ckt - http://irfaiad.virtualave.net/
Comment: PGP Signed for message verification and/or encryption
Comment: KeyID: 0xD68B61E851046CFD
iQA/AwUBOeH3NdaLYehRBGz9EQLxqgCfS+JJ67Lv4x7p5EU2w7MgvJTOm2oAoOO8
p4DPorPfCpM9ERleum5i8/W6
=Dmrb
-----END PGP SIGNATURE-----
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
