Well, I am also trying to compare CF+NT+MSSQL vs CF+Linux+MSSQL. It seems to
me that the Linux
database connection is about 10% slower than NT connection. I am not using
MySql because I am not sure if it
is a good choice for enterprise environment. Well, it is just a rough test.
if anyone has done a detailed
test, please advise.
Thanks
----- Original Message -----
From: "Michael Sheldon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 21, 2000 8:15 AM
Subject: RE: CF on a Unix server
> SQL Server 7 vs. MySQL is *not* a fair comparison, and the fact that your
DB
> and Web server are now on the same machine makes it an even more uneven
> comparison.
>
> Michael J. Sheldon
> http://www.desertraven.com/
> PGP Key Available on Request
>
> -----Original Message-----
> From: vince [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 21, 2000 05:50
> To: [EMAIL PROTECTED]
> Subject: RE: CF on a Unix server
>
>
> hi,
> Well, on NT it was a CF 4.5 server. And we were on a independent
machine.
> Now the machine we are on is a shared mySQL and CF 4.5 for Unix
>
> We ported to Unix because for some reason NT kept demanding for more
> resources.
>
> And yeah, all the development was done keeping NT in mind. Now that we
are
> shifting
> servers, Im wondering if problems like database connectivity are part of
> the whole shifting
> process. ?
> Does a CF-NT (with SQL7) site, face problems if moved to a CF-Unix and
> mySQL system ?
> Has anyone tried to do something like this? and If so .. were there
> similar problems that
> were faced ?
>
>
> Thanks
> Vin
> At 07:31 AM 7/21/00 -0400, Conrad, Christopher wrote:
> >What version are you running ? Pre 4.5 was developed on NT and ported -
so
> >it will be faster. CF 4.5 is a true Solaris build. However you problems
> >could be diff between the DB drivers under NT and Solaris.
> >
> >Chris
> >
> >Christopher Conrad
> >Victoria's Secret Catalogue
> >http://www.VictoriasSecret.com
> >Senior.Programmer.Analyst
> >614.337.5653
> >[EMAIL PROTECTED]
> >
> >
> > > -----Original Message-----
> > > From: vince [SMTP:[EMAIL PROTECTED]]
> > > Sent: Friday, July 21, 2000 4:01 AM
> > > To: [EMAIL PROTECTED]
> > > Subject: CF on a Unix server
> > >
> > > hi,
> > > We have just moved from a NT server to a Unix server.
> > > But for some strange reason, there seems to be a considerable time
> > > difference between NT and Unix. (With CF on Unix accessing a mySQL
> > > database)
> > > I shocked to say I find NT much faster.
> > >
> > > That's why I figuring out that there is something that is being done
> > > wrong.
> > > The database is a small one with just over 10,000 records. And for CF
to
> > > take more than
> > > 30 seconds to execute and manipulate the query this i find quite
> strange.
> > >
> > > There are no temp files that are created on CF for unix. Am I correct
?
> > > Couuld this
> > > be the reason why there is a longer delay ??
> > >
> > > //Vin//
> > >
> >
>
> --------------------------------------------------------------------------
> > > ----
> > > 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.
>
> --------------------------------------------------------------------------
--
> --
> 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.
>
------------------------------------------------------------------------------
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.
