RE: Urgent: Performance Help
But realistically no-one runs MySQL in a live production environment. Do they? None of the major clients I service do. Oracle is a given now but MSSQL seems to be gaining ground lost with XML support. Still no sign of SQL Server 2003 in this part of the world yet. Developer editions of Oracle are certainly available - very resource intensive (huge install requirements) - and MS SQL Server 2000 Personal Edition could be an option. I had the option of MSSQL Standard or Personal after a system rebuild and have gotten personal for now. On a dev machine it is more than enough - I did not bother installing Access at all. And to assume that Access will upsize to SQL depends entirely upon the version of Access you are using. More often than not it is easier to recreate the database in SQL Server with test data. If you are serious about performance be serious about using a dbms that can cut it. Oracle, MSSQL and then maybe MySQL. -Original Message- From: paris lundis [mailto:[EMAIL PROTECTED] Sent: Thursday, 18 September 2003 7:38 AM To: CF-Talk Subject: Re: Urgent: Performance Help At the starting level you seem to be at with the site and databases, I'd recommend taking the MySQL route its free... runs on more platforms.. runs darn fast... If you think your clients/company will be a Windoze shop or clients will be wanting MS solutions I'd say pickup MsSQL afterwards... Simple selects, writes and updates aren't very different between them... syntax can be annoying... Transactions and complicated sub queries, mass unions, etc. typically are beyond what most folks actually need... Finally, MySQL + CF can be setup on a smallish computer within your home /office and run pretty well... Be sure to setup dev environment of your own before deploying your monster apps... ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137440 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
MySQL and performance [Was: Re: Urgent: Performance Help]
Ah here we go with the MySQL stuff again. Couple of references to refute the myths PERFORMANCE IS POOR? Let's start with the big eWeek article http://www.eweek.com/article2/0,3959,293,00.asp, particularly the preformance comparison (summary: neck and neck with Oracle under heavy load; both better than the other 3) between Oracle, MySQL, MS-SQL, Sybase, and DB2. Particularly the graphs of performance, etc at this URL: http://www.eweek.com/slideshow/0,3018,sid=0s=1590a=23120,00.asp And while there are some issues with the methodology (eg MySQL AB sent engineers to help tune the db, a request that most of the other companies ignored), the comparison is pretty fair and they are pretty objective testers. NO ONE USES IT? Plenty of people run MySQL in a production environment. Here are a few *recent* examples from the MySQL AB homepage: MySQL's High Availability Works for Red One Aviation Cox Communications Powers Massive Data Warehouse with MySQL The AP Relies on MySQL for Transaction-Heavy News Delivery System Sterling Commerce Taps MySQL To Power Gentran Integration Suite For Global 5000 Companies MySQL and SGI Partner to Deliver High Performance Database Computing with MySQL on the SGI Altix 3000 Supercluster Dell Researchers Deem MySQL Replication Cluster Easy, Effective for High Volume Applications Danish Center for Biological Sequence Analysis Uses MySQL as Data Management Engine in Massive Supercomputer-Based Research Project Plus Yahoo is using it internally for many, many applications and rolling it out behind some of their new public applications (PHP and MySQL to be precise). Their PHP manager and I discussed it during my class on MySQL DataWarehousing at OSCON this year. Plenty of other corporations/groups were there rolling out MySQL apps. Columbia University. O'Reilly Publishing (big surprise), etc, etc. That said, I'm a hardcore MS-SQL server guy as well. I've been DBA for a company with 22+ servers in 4 countries. I've pushed it for a number of client projects. The argument in favor of MS-SQL Server has often been It's like Oracle for most applications, but far cheaper which is a fair statement. Same thing can be said of MySQL in many instances (not all, and there are certainly places to not use it) but the AP Newswire delivers (full text) content to 11,000 *concurrent* users with MySQL. SAP is putting the MySQL guys in charge of all future work/maintenance on their SAPDb product, which is no MaxDB for MySQL in marketing lingo. And plenty of open source applications come ready to use MySQL, which gets them in the enterprise as more and more off-the-shelf oss applications are used in corporations. MySQL came out of a data warehousing project -- and is very well suited to it (since transactions aren't a big deal in that world. The additional of InnoDB and BDB tables with transactional support (yes, they are ACID, just like MS-SQL and Oracle) provided the operational side of the house. To follow up on the original point in the post, it's not always If you are serious about performance be serious about using a dbms that can cut it. Oracle, MSSQL and then maybe MySQL. if you believe eWeek, it's more like Oracle/MySQL, then MS-SQL or DB2 or Sybase. And on a purely techical note, the JDBC driver for MySQL that Mark Matthews (now a MySQL employee) wrote *amazingly* fast. The MS-SQL JDBC driver (which MS licensed from DataDirect I've been led to understand) blows. Who cares which db is faster when you can't get the data back to the client efficiently (of course, you could always get JTurbo from NewAtlanta and fix that problem). Plus you can basically put the whole MySQL database in memory by changing the cache size --- run MySQL on an AMD Opteron 64-bit Linux platform with 8GB of RAM , and you're talking amazing speed for pretty huge databases since the disk access speed (slowest step for most db operations) is eliminated. So of course consider Oracle, DB2 (which is now approaching the same price point as MS-SQL) and MS-SQL and even Sybase for your project. But don't discount MySQL out of hand. Or PostgreSQL, but thats a completely different story and I'm sure Jochem is a better source for that than me :) Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Peter Tilbrook [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:33 AM Subject: RE: Urgent: Performance Help But realistically no-one runs MySQL in a live production environment. Do they? None of the major clients I service do. Oracle is a given now but MSSQL seems to be gaining ground lost with XML support. Still no sign of SQL Server 2003 in this part of the world yet. Developer editions of Oracle are certainly available - very resource intensive (huge install requirements) - and MS SQL Server 2000 Personal Edition could be an option. I had the option of MSSQL Standard or Personal after a system rebuild and have gotten
Re: Urgent: Performance Help
- Original Message - From: Jim Campbell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:51 PM Subject: Re: Urgent: Performance Help It's interesting they'd charge you more for MySQL than Access (since I assume they'll have more tech support issues with Access ;) Actually it's pretty straightforward why it would cost more -- you have to set up users, dbs, etc in MySQL (or MS-SQL) -- you can't simply copy up a file. In both cases you need to set up the datasource connection (ODBC/CF) but that's it for Access. However, MySQL is not that hard to learn. You don't have transactional support nor real foreign keys, etc. There are a number of differences that we've discussed before on this list, and you should be able to pick them up for the archives. arrghhh Agggh! IT DOES HAVE TRANSACTIONAL SUPPORT. MyISAM tables do not. BDB and InnoDB tables *do*. You pick your table type and that determines what capabilities that table has -- you can even mix and match table types in the same db so that the operational tables are ACID (orders for instance) while the logging tables are MyISAM. Plus you can load all the lookup data (states, etc) into HEAP tables which reside only in memory. Oh, and there's the MERGE tables for doing basic database partitioning (or for very, very simple db views). Of course HEAP and MERGE tables are non-transactional /arrghhh SQL Server might be a better choice - it should be able to recognize your tables/datatypes from Access without any problems, and if you're using things like transactions, the migration should be fairly painless. _Fairly_ painless, not necessarily totally painless. Unless you foolishly picked boolean fields in Access. Access even converts bit fields (0/1) in SQL Server to (0/-1) when you link tables through the ODBC driver. But other than that (and any code that dealt with booleans) you're in good shape. Best of luck. - Jim Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137544 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: MySQL and performance [Was: Re: Urgent: Performance Help]
Here's my 2 cents Alot of folks say use MySQL because it's free. The problem I have with that is that you have to write extra code to make up for what it's missing (i.e. views, triggers, stored procs). So that drives up development cost and code maintenance costs...so free isn't so free. Granted if it's used in ceratian situation as John Paul mentioned...then sure...go for itbut for full-blown apps...I'm not sold...PostgreSQL looks much better to me in that arena (although you'll still have to pry SQL Server from my cold dead hands) ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: John Paul Ashenfelter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 10:29 AM Subject: MySQL and performance [Was: Re: Urgent: Performance Help] Ah here we go with the MySQL stuff again. Couple of references to refute the myths PERFORMANCE IS POOR? Let's start with the big eWeek article http://www.eweek.com/article2/0,3959,293,00.asp, particularly the preformance comparison (summary: neck and neck with Oracle under heavy load; both better than the other 3) between Oracle, MySQL, MS-SQL, Sybase, and DB2. Particularly the graphs of performance, etc at this URL: http://www.eweek.com/slideshow/0,3018,sid=0s=1590a=23120,00.asp And while there are some issues with the methodology (eg MySQL AB sent engineers to help tune the db, a request that most of the other companies ignored), the comparison is pretty fair and they are pretty objective testers. NO ONE USES IT? Plenty of people run MySQL in a production environment. Here are a few *recent* examples from the MySQL AB homepage: MySQL's High Availability Works for Red One Aviation Cox Communications Powers Massive Data Warehouse with MySQL The AP Relies on MySQL for Transaction-Heavy News Delivery System Sterling Commerce Taps MySQL To Power Gentran Integration Suite For Global 5000 Companies MySQL and SGI Partner to Deliver High Performance Database Computing with MySQL on the SGI Altix 3000 Supercluster Dell Researchers Deem MySQL Replication Cluster Easy, Effective for High Volume Applications Danish Center for Biological Sequence Analysis Uses MySQL as Data Management Engine in Massive Supercomputer-Based Research Project Plus Yahoo is using it internally for many, many applications and rolling it out behind some of their new public applications (PHP and MySQL to be precise). Their PHP manager and I discussed it during my class on MySQL DataWarehousing at OSCON this year. Plenty of other corporations/groups were there rolling out MySQL apps. Columbia University. O'Reilly Publishing (big surprise), etc, etc. That said, I'm a hardcore MS-SQL server guy as well. I've been DBA for a company with 22+ servers in 4 countries. I've pushed it for a number of client projects. The argument in favor of MS-SQL Server has often been It's like Oracle for most applications, but far cheaper which is a fair statement. Same thing can be said of MySQL in many instances (not all, and there are certainly places to not use it) but the AP Newswire delivers (full text) content to 11,000 *concurrent* users with MySQL. SAP is putting the MySQL guys in charge of all future work/maintenance on their SAPDb product, which is no MaxDB for MySQL in marketing lingo. And plenty of open source applications come ready to use MySQL, which gets them in the enterprise as more and more off-the-shelf oss applications are used in corporations. MySQL came out of a data warehousing project -- and is very well suited to it (since transactions aren't a big deal in that world. The additional of InnoDB and BDB tables with transactional support (yes, they are ACID, just like MS-SQL and Oracle) provided the operational side of the house. To follow up on the original point in the post, it's not always If you are serious about performance be serious about using a dbms that can cut it. Oracle, MSSQL and then maybe MySQL. if you believe eWeek, it's more like Oracle/MySQL, then MS-SQL or DB2 or Sybase. And on a purely techical note, the JDBC driver for MySQL that Mark Matthews (now a MySQL employee) wrote *amazingly* fast. The MS-SQL JDBC driver (which MS licensed from DataDirect I've been led to understand) blows. Who cares which db is faster when you can't get the data back to the client efficiently (of course, you could always get JTurbo from NewAtlanta and fix that problem). Plus you can basically put the whole MySQL database in memory by changing the cache size --- run MySQL on an AMD Opteron 64-bit Linux platform with 8GB
Re: MySQL and performance [Was: Re: Urgent: Performance Help]
Simple - just use a provider that will support the database of your choice. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all popular databases. ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 12:49 PM Subject: Re: MySQL and performance [Was: Re: Urgent: Performance Help] | Here's my 2 cents | | Alot of folks say use MySQL because it's free. The problem I have with that | is that you have to write extra code to make up for what it's missing (i.e. | views, triggers, stored procs). So that drives up development cost and code | maintenance costs...so free isn't so free. | | Granted if it's used in ceratian situation as John Paul mentioned...then | sure...go for itbut for full-blown apps...I'm not sold...PostgreSQL | looks much better to me in that arena (although you'll still have to pry SQL | Server from my cold dead hands) ;-) | | Cheers | | Bryan Stevenson B.Comm. | VP Director of E-Commerce Development | Electric Edge Systems Group Inc. | t. 250.920.8830 | e. [EMAIL PROTECTED] | | - | Macromedia Associate Partner | www.macromedia.com | - | Vancouver Island ColdFusion Users Group | Founder Director | www.cfug-vancouverisland.com | - Original Message - | From: John Paul Ashenfelter [EMAIL PROTECTED] | To: CF-Talk [EMAIL PROTECTED] | Sent: Thursday, September 18, 2003 10:29 AM | Subject: MySQL and performance [Was: Re: Urgent: Performance Help] | | | Ah here we go with the MySQL stuff again. Couple of references | to refute the myths | | PERFORMANCE IS POOR? | | Let's start with the big eWeek article | http://www.eweek.com/article2/0,3959,293,00.asp, particularly the | preformance comparison (summary: neck and neck with Oracle under heavy | load; | both better than the other 3) between Oracle, MySQL, MS-SQL, Sybase, and | DB2. Particularly the graphs of performance, etc at this URL: | http://www.eweek.com/slideshow/0,3018,sid=0s=1590a=23120,00.asp And | while | there are some issues with the methodology (eg MySQL AB sent engineers to | help tune the db, a request that most of the other companies ignored), the | comparison is pretty fair and they are pretty objective testers. | | NO ONE USES IT? | Plenty of people run MySQL in a production environment. Here are a few | *recent* examples from the MySQL AB homepage: | | MySQL's High Availability Works for Red One Aviation | Cox Communications Powers Massive Data Warehouse with MySQL | The AP Relies on MySQL for Transaction-Heavy News Delivery System | Sterling Commerce Taps MySQL To Power Gentran Integration Suite For Global | 5000 Companies | MySQL and SGI Partner to Deliver High Performance Database Computing with | MySQL on the SGI Altix 3000 Supercluster | Dell Researchers Deem MySQL Replication Cluster Easy, Effective for High | Volume Applications | Danish Center for Biological Sequence Analysis Uses MySQL as Data | Management | Engine in Massive Supercomputer-Based Research Project | | Plus Yahoo is using it internally for many, many applications and rolling | it | out behind some of their new public applications (PHP and MySQL to be | precise). Their PHP manager and I discussed it during my class on MySQL | DataWarehousing at OSCON this year. Plenty of other corporations/groups | were | there rolling out MySQL apps. Columbia University. O'Reilly Publishing | (big | surprise), etc, etc. | | That said, I'm a hardcore MS-SQL server guy as well. I've been DBA for a | company with 22+ servers in 4 countries. I've pushed it for a number of | client projects. The argument in favor of MS-SQL Server has often been | It's | like Oracle for most applications, but far cheaper which is a fair | statement. Same thing can be said of MySQL in many instances (not all, and | there are certainly places to not use it) but the AP Newswire delivers | (full | text) content to 11,000 *concurrent* users with MySQL. SAP is putting the | MySQL guys in charge of all future work/maintenance on their SAPDb | product, | which is no MaxDB for MySQL in marketing lingo. And plenty of open source | applications come ready to use MySQL, which gets them in the enterprise as | more and more off-the-shelf oss applications are used in corporations. | | MySQL came out of a data warehousing project -- and is very well suited to | it (since transactions aren't a big deal in that world. The additional of | InnoDB and BDB tables with transactional
Re: MySQL and performance [Was: Re: Urgent: Performance Help]
There are plenty of full-blown apps that use MySQL. Some apps simply don't need transactional support. Some don't need views. Some don't need triggers. Some don't need stored procs. Some need all of them, some none. I think the whole free issue for open source is missing the point -- in no way is it free. There's learning costs, possibly transition costs (eg Access to MySQL) but that's true of any technology you roll out for the first time. MS-SQL has costs, not just the upfront $$$ for the license. There's training, admin, etc. With MySQL (and other oss software), you get open source code -- no more, no less. I happily steer clients towards MSDE for small projects if their application is likely to need the capabilities of SQL-Server, since that's a pretty smooth upgrade path. It's free too. As far as PostgreSQL and MySQL, they're certainly different animals. I do a lot of mixed development (Win/Linux) and don't like compiling Postgres distros (or running under VMWare, etc) so I lean towards MySQL since it's easy to roll out in heterogeneous environments. Plus I do a lot more data warehousing and reporting systems, where MySQL's strengths shine. My data center has 3 boxes running MySQL and 1 running MS-SQL. The last corporatin I worked for had 24 MS-SQL and no anything else. The current gig has 2 MS-SQL and 3 MySQL boxes. Go figure :) Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 1:49 PM Subject: Re: MySQL and performance [Was: Re: Urgent: Performance Help] Here's my 2 cents Alot of folks say use MySQL because it's free. The problem I have with that is that you have to write extra code to make up for what it's missing (i.e. views, triggers, stored procs). So that drives up development cost and code maintenance costs...so free isn't so free. Granted if it's used in ceratian situation as John Paul mentioned...then sure...go for itbut for full-blown apps...I'm not sold...PostgreSQL looks much better to me in that arena (although you'll still have to pry SQL Server from my cold dead hands) ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: John Paul Ashenfelter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 10:29 AM Subject: MySQL and performance [Was: Re: Urgent: Performance Help] Ah here we go with the MySQL stuff again. Couple of references to refute the myths PERFORMANCE IS POOR? Let's start with the big eWeek article http://www.eweek.com/article2/0,3959,293,00.asp, particularly the preformance comparison (summary: neck and neck with Oracle under heavy load; both better than the other 3) between Oracle, MySQL, MS-SQL, Sybase, and DB2. Particularly the graphs of performance, etc at this URL: http://www.eweek.com/slideshow/0,3018,sid=0s=1590a=23120,00.asp And while there are some issues with the methodology (eg MySQL AB sent engineers to help tune the db, a request that most of the other companies ignored), the comparison is pretty fair and they are pretty objective testers. NO ONE USES IT? Plenty of people run MySQL in a production environment. Here are a few *recent* examples from the MySQL AB homepage: MySQL's High Availability Works for Red One Aviation Cox Communications Powers Massive Data Warehouse with MySQL The AP Relies on MySQL for Transaction-Heavy News Delivery System Sterling Commerce Taps MySQL To Power Gentran Integration Suite For Global 5000 Companies MySQL and SGI Partner to Deliver High Performance Database Computing with MySQL on the SGI Altix 3000 Supercluster Dell Researchers Deem MySQL Replication Cluster Easy, Effective for High Volume Applications Danish Center for Biological Sequence Analysis Uses MySQL as Data Management Engine in Massive Supercomputer-Based Research Project Plus Yahoo is using it internally for many, many applications and rolling it out behind some of their new public applications (PHP and MySQL to be precise). Their PHP manager and I discussed it during my class on MySQL DataWarehousing at OSCON this year. Plenty of other corporations/groups were there rolling out MySQL apps. Columbia University. O'Reilly Publishing (big surprise), etc, etc. That said, I'm a hardcore MS-SQL server guy as well. I've been DBA for a company with 22+ servers in 4 countries. I've pushed it for a number of client projects. The argument in favor of MS-SQL Server has often
Re:MySQL and performance [Was: Re: Urgent: Performance Help]
Optimize MySQL: http://www.databasejournal.com/features/mysql/article.php/1382791 Hope that helps - mga ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137606 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Urgent: Performance Help
John Paul Ashenfelter wrote: From: Jim Campbell [EMAIL PROTECTED] It's interesting they'd charge you more for MySQL than Access (since I assume they'll have more tech support issues with Access ;) Actually it's pretty straightforward why it would cost more -- you have to set up users, dbs, etc in MySQL (or MS-SQL) -- you can't simply copy up a file. In both cases you need to set up the datasource connection (ODBC/CF) but that's it for Access. In both cases, it is just a matter of writing a template that will do this for you. SQL Server might be a better choice - it should be able to recognize your tables/datatypes from Access without any problems, and if you're using things like transactions, the migration should be fairly painless. _Fairly_ painless, not necessarily totally painless. Unless you foolishly picked boolean fields in Access. Access even converts bit fields (0/1) in SQL Server to (0/-1) when you link tables through the ODBC driver. But other than that (and any code that dealt with booleans) you're in good shape. The Access/MS SQL Server conversion might be extra difficult with booleans in Access, but that is an MS SQL Server shortcomming. The problem is that MS SQL Server does not recognize the SQL literals TRUE and FALSE which Access recognizes, but other databases do not suffer from this shortcomming. Jochem ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137616 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: MySQL and performance [Was: Re: Urgent: Performance Help]
John Paul Ashenfelter wrote: I think the whole free issue for open source is missing the point Most people miss the point. Free is not about the price, free is about the freedom to do with software whatever you want to do with it. BSD/MIT/X11 rocks ;-) Jochem ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137618 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: MySQL and performance [Was: Re: Urgent: Performance Help]
John Paul Ashenfelter wrote: PERFORMANCE IS POOR? Yes it is :-) For one of my applications at least, MySQL's inability to scan indexes in both directions quite literally kills it (who cares that MySQL is 2 times faster on 80% of the queries, when it is 200 times slower on the rest). On the other hand, we have people that get great performance from MySQL: http://www.eweek.com/article2/0,3959,293,00.asp So the conclusion is the same as always: There is no point in trusting somebody elses benchmarks (not even mine :-), you need to run your own benchmarks, designed for your own application and with your own dataset. OT Their PHP manager What did he have to say about PHP switching from MySQL to SQLLite? /OT But don't discount MySQL out of hand. Or PostgreSQL, but thats a completely different story and I'm sure Jochem is a better source for that than me :) The story is the same as always: every application is different BTW, I am convinced that if you take out the nobody ever got fired for buying Oracle factor for people solliciting information about databases on this list, it pretty much becomes nobody ever buys Oracle. (Not because Oracle isn't great (it is), but because when you really need the features you should have a DBA to make that decision for you instead of sollicit opinions on this list.) Jochem ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137619 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Urgent: Performance Help
Your problem might lie with Access - I've had plenty of problems with Access and ColdFusion - especially with keeping threads open and bogging down the system - and always on servers that handle many simultaneous requests. Can you use a different database with them? PostgreSQL? SQL Server? MySQL? - Jim Andy Ousterhout wrote: No, don't recommend Viagrathe problem is I just won't stop. My ISP is accusing me of writing code that keeps threads open long after they should be closed and are threatening to shut down my site. Good news is that I don't have many users yet, Bad news is that they can't give me any details because they don't have their analytical software, Cognos, up yet. Is there a site anywhere that can help we walk through my code and try to figure out what the problem is? Running MX and Microsoft Access. It runs fine as a single user on my PC. Thanks for anything you can give me Andy ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137369 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Urgent: Performance Help
access has been known at some point (amount of connections or maybe lines in the database) to hose up, what that means? not sure, but I know this, if at all possible, STAY AWAY FROM ACCESS tony tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:24 PM To: CF-Talk Subject: Urgent: Performance Help No, don't recommend Viagrathe problem is I just won't stop. My ISP is accusing me of writing code that keeps threads open long after they should be closed and are threatening to shut down my site. Good news is that I don't have many users yet, Bad news is that they can't give me any details because they don't have their analytical software, Cognos, up yet. Is there a site anywhere that can help we walk through my code and try to figure out what the problem is? Running MX and Microsoft Access. It runs fine as a single user on my PC. Thanks for anything you can give me Andy ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137371 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Urgent: Performance Help
Show do they know its you if they can't prove it? One guess is that they may be view database connections from perfmon which may be pointing to your domain. How big is your access DB? Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:24 PM To: CF-Talk Subject: Urgent: Performance Help No, don't recommend Viagrathe problem is I just won't stop. My ISP is accusing me of writing code that keeps threads open long after they should be closed and are threatening to shut down my site. Good news is that I don't have many users yet, Bad news is that they can't give me any details because they don't have their analytical software, Cognos, up yet. Is there a site anywhere that can help we walk through my code and try to figure out what the problem is? Running MX and Microsoft Access. It runs fine as a single user on my PC. Thanks for anything you can give me Andy ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137370 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Urgent: Performance Help
Access tends to 'abandon' connections... a fair amount of memory loss with any large usage on a server.. Access isn't good at all for shared hosting company environments... Easy way to hose a server... Find out if they have your DSN maintaining connections ... depending on the application you will or won't want to enable maintain connections... I have found that if your are doing lots of database activity to leave it on with Access... There is also the timeout to maintain DSN connection... try putting that at 1-5 minutes.. probably set at 0 default now... -paris -- Original Message -- From: Tony Weeg [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 17 Sep 2003 16:33:45 -0400 access has been known at some point (amount of connections or maybe lines in the database) to hose up, what that means? not sure, but I know this, if at all possible, STAY AWAY FROM ACCESS tony tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:24 PM To: CF-Talk Subject: Urgent: Performance Help No, don't recommend Viagrathe problem is I just won't stop. My ISP is accusing me of writing code that keeps threads open long after they should be closed and are threatening to shut down my site. Good news is that I don't have many users yet, Bad news is that they can't give me any details because they don't have their analytical software, Cognos, up yet. Is there a site anywhere that can help we walk through my code and try to figure out what the problem is? Running MX and Microsoft Access. It runs fine as a single user on my PC. Thanks for anything you can give me Andy ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137372 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Urgent: Performance Help
Jim, I've asked them to look specifically at the Access connection, because I have heard that also. They have MySQL and SQL Server, for more $$$. I also would have to learn them, which would take time. I was hoping to put off moving to a real engine after I had a site that might drive some traffic. I may have to change my plans. Thanks Andy -Original Message- From: Jim Campbell [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:32 PM To: CF-Talk Subject: Re: Urgent: Performance Help Your problem might lie with Access - I've had plenty of problems with Access and ColdFusion - especially with keeping threads open and bogging down the system - and always on servers that handle many simultaneous requests. Can you use a different database with them? PostgreSQL? SQL Server? MySQL? - Jim Andy Ousterhout wrote: No, don't recommend Viagrathe problem is I just won't stop. My ISP is accusing me of writing code that keeps threads open long after they should be closed and are threatening to shut down my site. Good news is that I don't have many users yet, Bad news is that they can't give me any details because they don't have their analytical software, Cognos, up yet. Is there a site anywhere that can help we walk through my code and try to figure out what the problem is? Running MX and Microsoft Access. It runs fine as a single user on my PC. Thanks for anything you can give me Andy ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137377 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Urgent: Performance Help
Access database is 15 tables and 15 Meg. Pretty small right now. And I just compressed it last night. Very few inserts,updates and deletes right now, mostly view. I'll ask them to monitor the DB connections Thanks, Andy -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:32 PM To: CF-Talk Subject: RE: Urgent: Performance Help Show do they know its you if they can't prove it? One guess is that they may be view database connections from perfmon which may be pointing to your domain. How big is your access DB? Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:24 PM To: CF-Talk Subject: Urgent: Performance Help No, don't recommend Viagrathe problem is I just won't stop. My ISP is accusing me of writing code that keeps threads open long after they should be closed and are threatening to shut down my site. Good news is that I don't have many users yet, Bad news is that they can't give me any details because they don't have their analytical software, Cognos, up yet. Is there a site anywhere that can help we walk through my code and try to figure out what the problem is? Running MX and Microsoft Access. It runs fine as a single user on my PC. Thanks for anything you can give me Andy ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137379 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Urgent: Performance Help
That seems to be the consensus. I knew this going in, but thought that I could get some of my site out first, then change. This may not be possible... Andy -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:34 PM To: CF-Talk Subject: RE: Urgent: Performance Help access has been known at some point (amount of connections or maybe lines in the database) to hose up, what that means? not sure, but I know this, if at all possible, STAY AWAY FROM ACCESS tony tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:24 PM To: CF-Talk Subject: Urgent: Performance Help No, don't recommend Viagrathe problem is I just won't stop. My ISP is accusing me of writing code that keeps threads open long after they should be closed and are threatening to shut down my site. Good news is that I don't have many users yet, Bad news is that they can't give me any details because they don't have their analytical software, Cognos, up yet. Is there a site anywhere that can help we walk through my code and try to figure out what the problem is? Running MX and Microsoft Access. It runs fine as a single user on my PC. Thanks for anything you can give me Andy ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137380 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Urgent: Performance Help
Andy Ousterhout wrote: My ISP is accusing me of writing code that keeps threads open long after they should be closed and are threatening to shut down my site. Good news is that I don't have many users yet, Bad news is that they can't give me any details because they don't have their analytical software, Cognos, up yet. Then how can they tell it is your site that is keeping threads open? Please ask them how they found that out, it may be important to solving the issue. Is there a site anywhere that can help we walk through my code and try to figure out what the problem is? Running MX and Microsoft Access. It runs fine as a single user on my PC. Does Access use persisent connections? Which driver are they using for Access? Jochem ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137384 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Urgent: Performance Help
It's interesting they'd charge you more for MySQL than Access (since I assume they'll have more tech support issues with Access ;) However, MySQL is not that hard to learn. You don't have transactional support nor real foreign keys, etc. There are a number of differences that we've discussed before on this list, and you should be able to pick them up for the archives. SQL Server might be a better choice - it should be able to recognize your tables/datatypes from Access without any problems, and if you're using things like transactions, the migration should be fairly painless. _Fairly_ painless, not necessarily totally painless. Best of luck. - Jim Andy Ousterhout wrote: Jim, I've asked them to look specifically at the Access connection, because I have heard that also. They have MySQL and SQL Server, for more $$$. I also would have to learn them, which would take time. I was hoping to put off moving to a real engine after I had a site that might drive some traffic. I may have to change my plans. Thanks Andy -Original Message- From: Jim Campbell [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:32 PM To: CF-Talk Subject: Re: Urgent: Performance Help Your problem might lie with Access - I've had plenty of problems with Access and ColdFusion - especially with keeping threads open and bogging down the system - and always on servers that handle many simultaneous requests. Can you use a different database with them? PostgreSQL? SQL Server? MySQL? - Jim Andy Ousterhout wrote: No, don't recommend Viagrathe problem is I just won't stop. My ISP is accusing me of writing code that keeps threads open long after they should be closed and are threatening to shut down my site. Good news is that I don't have many users yet, Bad news is that they can't give me any details because they don't have their analytical software, Cognos, up yet. Is there a site anywhere that can help we walk through my code and try to figure out what the problem is? Running MX and Microsoft Access. It runs fine as a single user on my PC. Thanks for anything you can give me Andy ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137385 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Urgent: Performance Help
Having come from where you are at not that long ago, I can tell you that picking up the basics of MS SQL server will be very easy. The parts of Access that you use in a CF application are fairly similar to the parts of MS SQL you will use for a CF application, the creation of tables, fields and relationships. Adding, editing and deleting are all almost the same. Now of course there is a LOT more to MS SQL, but the vast majority of this stuff falls under the DBA role, and that person is at the ISP. So, unless you are planning on completely taking over the database either in-house or out. You shouldn't have to worry about many of these issues. At least not just yet. HTH -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 1:43 PM To: CF-Talk Subject: RE: Urgent: Performance Help Jim, I've asked them to look specifically at the Access connection, because I have heard that also. They have MySQL and SQL Server, for more $$$. I also would have to learn them, which would take time. I was hoping to put off moving to a real engine after I had a site that might drive some traffic. I may have to change my plans. Thanks Andy -Original Message- From: Jim Campbell [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:32 PM To: CF-Talk Subject: Re: Urgent: Performance Help Your problem might lie with Access - I've had plenty of problems with Access and ColdFusion - especially with keeping threads open and bogging down the system - and always on servers that handle many simultaneous requests. Can you use a different database with them? PostgreSQL? SQL Server? MySQL? - Jim Andy Ousterhout wrote: No, don't recommend Viagrathe problem is I just won't stop. My ISP is accusing me of writing code that keeps threads open long after they should be closed and are threatening to shut down my site. Good news is that I don't have many users yet, Bad news is that they can't give me any details because they don't have their analytical software, Cognos, up yet. Is there a site anywhere that can help we walk through my code and try to figure out what the problem is? Running MX and Microsoft Access. It runs fine as a single user on my PC. Thanks for anything you can give me Andy ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137386 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Urgent: Performance Help
Andy Ousterhout wrote: I've asked them to look specifically at the Access connection, because I have heard that also. They have MySQL and SQL Server, for more $$$. I also would have to learn them, which would take time. I was hoping to put off moving to a real engine after I had a site that might drive some traffic. I may have to change my plans. While not on MX, I have some experience with Access and CF. If your site is as lightly loaded as you say, it shouldn't be the cause of your problems. Maybe wrong drivers/settings, but not the Jet engine itself. Not before you are doing 40+ queries per second. Jochem ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137388 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Urgent: Performance Help
At the starting level you seem to be at with the site and databases, I'd recommend taking the MySQL route its free... runs on more platforms.. runs darn fast... If you think your clients/company will be a Windoze shop or clients will be wanting MS solutions I'd say pickup MsSQL afterwards... Simple selects, writes and updates aren't very different between them... syntax can be annoying... Transactions and complicated sub queries, mass unions, etc. typically are beyond what most folks actually need... Finally, MySQL + CF can be setup on a smallish computer within your home /office and run pretty well... Be sure to setup dev environment of your own before deploying your monster apps... -paris -- Original Message -- From: Jim Campbell [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 17 Sep 2003 15:51:14 -0500 It's interesting they'd charge you more for MySQL than Access (since I assume they'll have more tech support issues with Access ;) However, MySQL is not that hard to learn. You don't have transactional support nor real foreign keys, etc. There are a number of differences that we've discussed before on this list, and you should be able to pick them up for the archives. SQL Server might be a better choice - it should be able to recognize your tables/datatypes from Access without any problems, and if you're using things like transactions, the migration should be fairly painless. _Fairly_ painless, not necessarily totally painless. Best of luck. - Jim Andy Ousterhout wrote: Jim, I've asked them to look specifically at the Access connection, because I have heard that also. They have MySQL and SQL Server, for more $$$. I also would have to learn them, which would take time. I was hoping to put off moving to a real engine after I had a site that might drive some traffic. I may have to change my plans. Thanks Andy -Original Message- From: Jim Campbell [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:32 PM To: CF-Talk Subject: Re: Urgent: Performance Help Your problem might lie with Access - I've had plenty of problems with Access and ColdFusion - especially with keeping threads open and bogging down the system - and always on servers that handle many simultaneous requests. Can you use a different database with them? PostgreSQL? SQL Server? MySQL? - Jim Andy Ousterhout wrote: No, don't recommend Viagrathe problem is I just won't stop. My ISP is accusing me of writing code that keeps threads open long after they should be closed and are threatening to shut down my site. Good news is that I don't have many users yet, Bad news is that they can't give me any details because they don't have their analytical software, Cognos, up yet. Is there a site anywhere that can help we walk through my code and try to figure out what the problem is? Running MX and Microsoft Access. It runs fine as a single user on my PC. Thanks for anything you can give me Andy ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137399 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com