Are you comparing a CF4.5 NT w/ MS SQLServer against CF4.5 Solaris w/mySQL ?
I'm not a mySQL man - however it would surprise me if mySQL would out
perform MS SQLServer. Sounds like this may be the slowdown.
Can you post your SQL statement - including your indexes on the tables.
Maybe that might clue us into the issue.
Regards,
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 8:50 AM
> 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.
