Re: CF MySQL
I am running the current version which is labeled ColdFusion MX. According to Macromedia, you need a Pentium Processor, 128M RAM Minimum, 256M RAM recommended, and 512M RAM preferred, and 350M id HD space. I was running MySQL, Apache standard secure, Sendmail for 25 people, ColdFusion MX, and a Firewall on a Celeron 400 with 384M Ram and slower IDE HDs. This configuration did noticeably slow down the server. After removing all large MySQL databases, leaving the server running did improve performance. Loading ColdFusion onto a Xeon 800 box w/Raid 5 SCSI, 512M RAM, running multiple HighHit Web Sites, with MySQL running some small databases, has not slowed performance at all. Personally, I am not sure which component caused the biggest slow down, CPU, Ram, or HD. My guess is RAM, then CPU, then HD. Personally, I have found, it best to have any SQL server running on the fastest box, with the most RAM, and your WebServer and CF on a 2nd box. This will give you the best performance without having to buy 2,4 or 8way processor boxes. Patrick At 03:58 PM 7/15/2003, William R. Mussatto wrote: I am currently running ColdFusion MX on my Linux Servers access both MySQL from different Linux Servers and MS SQL from a MS2000 WS. ColdFusion and MySQL are both available and run on both Win Linux machines. I also have PHP installed on Linux, but have never attempted to learn fully utilize PHP. ColdFusion is capable of access many DB programs. You simply need to tell CF how and where to access the Data. At 12:01 PM 7/15/2003, Andrew wrote: Hi All I've had a quick scoot about and could see anything about cold fusion and mysql is it possible to use this combination successfully if at all? Thanks Andrew Patrick J. Shoaf, Systems Engineer mailto:[EMAIL PROTECTED][EMAIL PROTECTED] Midmon Internet Services, LLC 100 Third Street Charleroi, PA 15022 http://www.midmon.com Phone: 724-483-2400 ext. 105 or888-638-6963 Fax: 724-489-4386 If you don't mind me asking, which version of the server are you using on Linux. We have been asked to set such a system up and are looking for background. Also, does CF put much of a load on the server. We are running Debian Stable. (woody). Thanks for any info. William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 Patrick J. Shoaf, Systems Engineer mailto:[EMAIL PROTECTED][EMAIL PROTECTED] Midmon Internet Services, LLC 100 Third Street Charleroi, PA 15022 http://www.midmon.com Phone: 724-483-2400 ext. 105 or888-638-6963 Fax: 724-489-4386 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: CF MySQL
Thanks Curtis, interesting indeed... presumably MySQL is in a different location as CF runs off NT4 or is MySQL a win version? The reason I am asking is because a solution has been presented to me in CF and MS SQL which I think will restrict future development and wondered whether a conversion to PHP and MySQL in the future be smooth or a waste of time. Not necessarily a full conversion but addons to the site at least. Andrew -Original Message- From: Curtis Maurand [mailto:Curtis Maurand] Sent: 15 July 2003 17:02 To: [EMAIL PROTECTED] Subject: Re: CF MySQL Set up your ODBC DSN using the MyODBC driver. Set up your database. declare your dsn as normal in cold fusion. have fun. On Tuesday 15 July 2003 12:01, Andrew wrote: Hi All I've had a quick scoot about and could see anything about cold fusion and mysql is it possible to use this combination successfully if at all? Thanks Andrew --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.500 / Virus Database: 298 - Release Date: 10/07/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: CF MySQL
Contents are Direct Alliance Corporation CONFIDENTIAL - Andrew, I have setup all the environments you are talking about. CF with MS SQL is much easier to setup and get going than PHP and mysql. However I have see twice the speed and stability with my applications that are written in PHP and MYSQL. I admit that struggling through all the setup can be cumbersome, but in the end it pays off. If you can get both PHP and MYSQL up on a Linux box even better. I have been certified in CF and used it for over 4 years. CF does have a rapid deployment phase and works well with mysql. But I believe php has a much more robust set of function, system, and networking capability that CF. Plus the key. Is that it's all FREE... CF + MS SQL + MS= $3000 + PHP + MYSQL + Linux = Freedom :) -Original Message- From: Andrew [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 9:24 AM Cc: MySQL-Lista Subject: RE: CF MySQL Thanks Curtis, interesting indeed... presumably MySQL is in a different location as CF runs off NT4 or is MySQL a win version? The reason I am asking is because a solution has been presented to me in CF and MS SQL which I think will restrict future development and wondered whether a conversion to PHP and MySQL in the future be smooth or a waste of time. Not necessarily a full conversion but addons to the site at least. Andrew -Original Message- From: Curtis Maurand [mailto:Curtis Maurand] Sent: 15 July 2003 17:02 To: [EMAIL PROTECTED] Subject: Re: CF MySQL Set up your ODBC DSN using the MyODBC driver. Set up your database. declare your dsn as normal in cold fusion. have fun. On Tuesday 15 July 2003 12:01, Andrew wrote: Hi All I've had a quick scoot about and could see anything about cold fusion and mysql is it possible to use this combination successfully if at all? Thanks Andrew --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.500 / Virus Database: 298 - Release Date: 10/07/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] This message is for the designated recipient(s) only and contains Direct Alliance Corporation privileged and confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this email is prohibited.
Re: CF MySQL
I am currently running ColdFusion MX on my Linux Servers access both MySQL from different Linux Servers and MS SQL from a MS2000 WS. ColdFusion and MySQL are both available and run on both Win Linux machines. I also have PHP installed on Linux, but have never attempted to learn fully utilize PHP. ColdFusion is capable of access many DB programs. You simply need to tell CF how and where to access the Data. At 12:01 PM 7/15/2003, Andrew wrote: Hi All I've had a quick scoot about and could see anything about cold fusion and mysql is it possible to use this combination successfully if at all? Thanks Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Patrick J. Shoaf, Systems Engineer mailto:[EMAIL PROTECTED][EMAIL PROTECTED] Midmon Internet Services, LLC 100 Third Street Charleroi, PA 15022 http://www.midmon.com Phone: 724-483-2400 ext. 105 or888-638-6963 Fax: 724-489-4386 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: CF MySQL
there is a windows version of mysql. However, I agree with this post as to have it all run on Linux would be cool. There is also a Linux version of Cold Fusion. Curtis On Tuesday 15 July 2003 14:15, Cory Lamle wrote: Contents are Direct Alliance Corporation CONFIDENTIAL - Andrew, I have setup all the environments you are talking about. CF with MS SQL is much easier to setup and get going than PHP and mysql. However I have see twice the speed and stability with my applications that are written in PHP and MYSQL. I admit that struggling through all the setup can be cumbersome, but in the end it pays off. If you can get both PHP and MYSQL up on a Linux box even better. I have been certified in CF and used it for over 4 years. CF does have a rapid deployment phase and works well with mysql. But I believe php has a much more robust set of function, system, and networking capability that CF. Plus the key. Is that it's all FREE... CF + MS SQL + MS= $3000 + PHP + MYSQL + Linux = Freedom :) -Original Message- From: Andrew [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 9:24 AM Cc: MySQL-Lista Subject: RE: CF MySQL Thanks Curtis, interesting indeed... presumably MySQL is in a different location as CF runs off NT4 or is MySQL a win version? The reason I am asking is because a solution has been presented to me in CF and MS SQL which I think will restrict future development and wondered whether a conversion to PHP and MySQL in the future be smooth or a waste of time. Not necessarily a full conversion but addons to the site at least. Andrew -Original Message- From: Curtis Maurand [mailto:Curtis Maurand] Sent: 15 July 2003 17:02 To: [EMAIL PROTECTED] Subject: Re: CF MySQL Set up your ODBC DSN using the MyODBC driver. Set up your database. declare your dsn as normal in cold fusion. have fun. On Tuesday 15 July 2003 12:01, Andrew wrote: Hi All I've had a quick scoot about and could see anything about cold fusion and mysql is it possible to use this combination successfully if at all? Thanks Andrew --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.500 / Virus Database: 298 - Release Date: 10/07/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
