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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF on a Unix server
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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF on a Unix server
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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF on a Unix server
What is your hardware setup like for these two environments ? Chris Christopher Conrad Victoria's Secret Catalogue http://www.VictoriasSecret.com Senior.Programmer.Analyst 614.337.5653 [EMAIL PROTECTED] -Original Message- From: Tieying Liu [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 21, 2000 1:16 PM To: [EMAIL PROTECTED] Subject: Re: CF on a Unix server 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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - -- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in
Re: CF on a Unix server
I am using P2400+128RAM for RedHat62 and Dual PPro 300+256RAM I know it is a lot different. I will do a test on one of the machines later. - Original Message - From: "Conrad, Christopher" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 21, 2000 10:22 AM Subject: RE: CF on a Unix server What is your hardware setup like for these two environments ? Chris Christopher Conrad Victoria's Secret Catalogue http://www.VictoriasSecret.com Senior.Programmer.Analyst 614.337.5653 [EMAIL PROTECTED] -Original Message- From: Tieying Liu [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 21, 2000 1:16 PM To: [EMAIL PROTECTED] Subject: Re: CF on a Unix server 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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - -- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://w
RE: CF on a Unix server
MySQL is not a good choice for Enterprise applications. Better choices would be PostGreSQL, Sybase, Oracle, etc... Michael J. Sheldon http://www.whitehat.com Phone: 480.804.8211 -Original Message- From: Tieying Liu [mailto:[EMAIL PROTECTED]] Sent: Friday, July 21, 2000 10:16 AM To: [EMAIL PROTECTED] Subject: Re: CF on a Unix server 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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lis