Re: MySQL charging hard?
Michael T. Tangorre wrote: I used to be a die hard SQL Server fan forever and ever always avoiding MySQL and Oracle until I needed to buy hosting myself and was a little weary of paying for SQL Server for a blog! So I took the plunge and went with MySQL. To be honest, I love it. I think as more features come out (hopefully at a quicker pace) the more MySQL will catch on. It already has a huge following, I was just so stuck on MS SQL Server that I didn't see it. Anyway, it will be interesting to see what format/syntax the stored procedures will take on as well as the triggers (Jochem, any insight??). Their stored procedure language is basically the same as DB2 (although of course advanced features such as recursive queries are not available). I have not seen working trigger support yet and not all datatypes will offer all features. Jochem ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195361 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL charging hard?
Will Tomlinson wrote: I like my GUI's! Is that such a bad thing? There are plenty of gui interfaces available for MySQL =) Although I have to admit, I like QueryAnalyzer a LOT more than any of the mysql gui tools I've tried. - Rick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195362 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL charging hard?
I am more in favor of NaviCat personally. I tried MySQLFront But did not care for it much. -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, February 18, 2005 8:40 AM To: CF-Talk Subject: Re: MySQL charging hard? Will Tomlinson wrote: I like my GUI's! Is that such a bad thing? There are plenty of gui interfaces available for MySQL =) Although I have to admit, I like QueryAnalyzer a LOT more than any of the mysql gui tools I've tried. - Rick ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195365 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL charging hard?
Rick That's an interesting post, in particular the fact that despite Oracle and MySQL being free (for your organization), you are moving to SQL server *because its easier to maintain*. Kola -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: 18 February 2005 03:18 To: CF-Talk Subject: Re: MySQL charging hard? Will Tomlinson wrote: What does everyone think about this? I used MySQL until I started using SP's. Then I HAD to go with SQL Server for my needs. What will this mean for the db market? In my department at Duke, we have databases in MySQL 4.1 and Oracle 9. I've found Oracle to be exceptionally difficult to maintain, since I'm not a DBA. MySQL is much easier. However, we've done some performance testing, pitting Oracle against MySQL and SQL Server... and we found that SQL Server - on a smaller machine - actually performed faster than both MySQL and Oracle. MySQL was good when small amounts of data were returned versus Oracle, but SQL Server was faster pretty much across the board. SQL Server is also easier to maintain. I like MySQL, and I will continue to use it for pretty much all of my freelance web development, unless my clients desire otherwise. But in our department at Duke, where we're dealing with very large datasets (millions of rows in several tables), we're going with SQL Server (ie, we're going to phase out Oracle *AND MySQL and switch to SQL Server, even though Oracle is free for us, and SQL Server is not.) - Rick -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 2/14/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195368 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL charging hard?
-Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] What does everyone think about this? I used MySQL until I started using SP's. Then I HAD to go with SQL Server for my needs. What will this mean for the db market? What about PostgreSQL? -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195370 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL charging hard?
From: Damien McKenna [mailto:[EMAIL PROTECTED] What about PostgreSQL? Interesting you mention that. I was just about to ask the list about it... who is using it... their impressions. I just downloaded it after reading some articles on it last night. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195372 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL charging hard?
Does not sound as if you Oracle tunned properly and being that you do not have DBA on staff that can make it challenging. With it tunned properly it runs great in my oppinion. Plus your applications may not be tunned properly either. I also Run SQL2K and it has its benefits as well. Dabbled little with MySql. Basically it comes down to what is best or the job and what it is you are willing to support -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Friday, February 18, 2005 9:06 AM To: CF-Talk Subject: RE: MySQL charging hard? -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] What does everyone think about this? I used MySQL until I started using SP's. Then I HAD to go with SQL Server for my needs. What will this mean for the db market? What about PostgreSQL? -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195373 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL charging hard?
[EMAIL PROTECTED] wrote: Rick That's an interesting post, in particular the fact that despite Oracle and MySQL being free (for your organization), you are moving to SQL server *because its easier to maintain*. That's a lot of it, but it's also been faster in almost all of our tests, and it's easier to back up and restore (keeping in mind that none of us are DBAs nor do any of us want to be DBAs). Doing security updates in Oracle is a pain. Doing backups and restores in Oracle is a pain. The learning curve on Oracle is just way too high - I'd rather be coding. MySQL backups are pretty easy, as are MySQL restores. Security updates are also pretty easy. At least for me, because I'm kind of a command line guy anyway. But for the others in my department, it probably wouldn't be. My boss always says What if you get hit by a bus. And MySQL simply didn't perform as well as SQL Server or Oracle. - Rick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195376 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL charging hard?
Eric Creese wrote: Does not sound as if you Oracle tunned properly and being that you do not have DBA on staff that can make it challenging. With it tunned properly it runs great in my oppinion. Plus your applications may not be tunned properly either. I also Run SQL2K and it has its benefits as well. Dabbled little with MySql. Basically it comes down to what is best or the job and what it is you are willing to support I don't doubt that Oracle can be very very fast. I even went to a week long oracle performance tuning class (taught by an Oracle employee, at an Oracle facility in Reston), but it was all just way too complicated. I bet if we had a DBA on staff, we'd be sticking with Oracle =) - Rick ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195377 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL charging hard?
Rick Root wrote: I bet if we had a DBA on staff, we'd be sticking with Oracle =) i bet if you had an oracle DBA on staff, there'd be a lot less of your staff around. it's great that mySQL is finally catching up, but don't forget these new features will be 1.0 while all the big iron db's have had these things for a zillion years. postgreSQL is a very capable database (and i'm a true blue ms sql server guy since version 6.5). got a good GUI admin. handles unicode. and right now, it's more extendable than sql server (though this may change w/sql server 2005). it's even got a very nice spatial database extension, postGIS that makes handling geographic data a breeze. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195379 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL charging hard?
Rick Root wrote: Will Tomlinson wrote: I like my GUI's! Is that such a bad thing? There are plenty of gui interfaces available for MySQL =) Although I have to admit, I like QueryAnalyzer a LOT more than any of the mysql gui tools I've tried. Have you tried the new Query Browser and Administrator apps? Not quite as powerful as the SQL Server Query Analyser, but quite good when used in concert (which is how they're supposed to be used). K. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195387 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL charging hard?
Michael T. Tangorre wrote: From: Damien McKenna [mailto:[EMAIL PROTECTED] What about PostgreSQL? Interesting you mention that. I was just about to ask the list about it... who is using it... their impressions. I just downloaded it after reading some articles on it last night. I use it and I like it. Since version 8 it has a native version for Windows. If you want to check it out, the installation should be painless. (One thing I love is that it is hardcoded in the executable that you can not run PostgreSQL as administrator. The installer takes care about creating a separate user for the service for you.) But you need to write down the password for the database superuser. After installation the most important issues are: - create databases in Unicode (UTF8) to work with CF MX/7 (IIRC you can't set this during installation yet) - set up a scheduled task that runs vacuum and analyze (see chapter 21 Routine database maintenance tasks) Nice things you can do and won't find in most other databases: - exotic datatypes, PostgreSQL has some special datatypes that can save you a lot of headaches (IP, MAC, interval, GIS etc.) - create your own datatypes, for instance: CREATE DOMAIN emailaddr AS TEXT CHECK (VALUE ~ '[EMAIL PROTECTED]'); CREATE TABLE subscriber ( IDINTEGER, email EMAILADDR, name TEXT, ... ... ) (OK, you will find this in most other databases. But I think this technique is undervalued so I mention it anyway:-) - explain query plans Admittedly not for everyone, but for me the output format of the PostgreSQL EXPLAIN ANALYZE command is the perfect match between completeness and readability: its format matches the scientific literature on query planners. (Probably because a significant part of that literature was developed on PostgreSQL.) - transactional DDL Drop a table, create a new one, change the definition, and if you don't like the result you just roll it back. - many procedural languages (C, R, Java, PHP, Perl, PL/pgSQL, Python) Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195393 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL charging hard?
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Since version 8 it has a native version for Windows. If you want to check it out, the installation should be painless. (One thing I love is that it is hardcoded in the executable that you can not run PostgreSQL as administrator. The installer takes care about creating a separate user for the service for you.) But you need to write down the password for the database superuser. After installation the most important issues are: - create databases in Unicode (UTF8) to work with CF MX/7 (IIRC you can't set this during installation yet) - set up a scheduled task that runs vacuum and analyze (see chapter 21 Routine database maintenance tasks) Nice things you can do and won't find in most other databases: - exotic datatypes, PostgreSQL has some special datatypes that can save you a lot of headaches (IP, MAC, interval, GIS etc.) - create your own datatypes, for instance: CREATE DOMAIN emailaddr AS TEXT CHECK (VALUE ~ '[EMAIL PROTECTED]'); CREATE TABLE subscriber ( IDINTEGER, email EMAILADDR, name TEXT, ... ... ) (OK, you will find this in most other databases. But I think this technique is undervalued so I mention it anyway:-) - explain query plans Admittedly not for everyone, but for me the output format of the PostgreSQL EXPLAIN ANALYZE command is the perfect match between completeness and readability: its format matches the scientific literature on query planners. (Probably because a significant part of that literature was developed on PostgreSQL.) - transactional DDL Drop a table, create a new one, change the definition, and if you don't like the result you just roll it back. - many procedural languages (C, R, Java, PHP, Perl, PL/pgSQL, Python) Thanks Jochem! I have it up and running now... pretty neat! I need to read through the docs this weekend and get a little more familiar but it seems pretty straightforward thus far. Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195398 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL charging hard?
On Fri, 18 Feb 2005 10:34:31 -0500, Rick Root [EMAIL PROTECTED] wrote: Eric Creese wrote: Does not sound as if you Oracle tunned properly and being that you do not have DBA on staff that can make it challenging. With it tunned properly it runs great in my oppinion. Plus your applications may not be tunned properly either. I also Run SQL2K and it has its benefits as well. Dabbled little with MySql. Basically it comes down to what is best or the job and what it is you are willing to support I don't doubt that Oracle can be very very fast. I even went to a week long oracle performance tuning class (taught by an Oracle employee, at an Oracle facility in Reston), but it was all just way too complicated. MySQL can also be *extremely* fast -- depending on how well you've tuned it and your specific needs. One really great part of MySQL is that each table can use a different handler, and the MyISAM tables are *very* fast for indexed reads and many inserts. Since they are *not* transaction safe, they don't have all the overhead of MS-SQL, Oracle, PostgreSQL, etc when you don't need that overhead (data warehousing for example). I just rewrote the training materials for MySQL's week-long MySQL intro course, which includes about 1.5 days on tuning. For many types of web applications MySQL properly tuned can easily compete with Oracle -- there's several presentations coming up at the MySQL Users Conf in April on multi-terabyte MySQL database projects... I bet if we had a DBA on staff, we'd be sticking with Oracle =) One thing about MS-SQL that's great is that it works really well *out of the box*. MySQL and Oracle out of the box may or may not be tuned properly. Simply enabling the query cache in MySQL 4.1+ can provide a drastic improvement in applications that do a lot of repeated read (blog, content delivery sites, catalogs) but you have to know about it. - Rick -- John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195401 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL charging hard?
On Fri, 18 Feb 2005 10:13:25 -0500, Michael T. Tangorre [EMAIL PROTECTED] wrote: From: Damien McKenna [mailto:[EMAIL PROTECTED] What about PostgreSQL? Interesting you mention that. I was just about to ask the list about it... who is using it... their impressions. I just downloaded it after reading some articles on it last night. I like PostgreSQL a lot, but until recently the fact that it didn't run reliably on Windows (I mean, cmon, installing under Cygwin?!!?) made it a hard-sell to replace MS-SQL Server, while MySQL has been running reliably on Windows for quite a while. PostgreSQL and MySQL are fundamentally different animals. MySQL originally came out of a data warehousing project as a replacement for msql (and old open source db) and is missing a number of features (transactions, views, stored procs, triggers) that have been slowly added in as it moves into more enterprise situations (and gains more mindshare). PostgreSQL was more of a direct replacement for Oracle, et al, and thus has had far better support for heavily OLTP-oriented applications. I personally keep both in my toolbox (and MS-SQL for some projects as well). Considering the nature of most web applications, I find MySQL handles just about everything that's necessary. Postgresql I think about more for serious enterprise applications where OLTP is far more crucial (though there's no inherent reason MySQL Innodb tables can't handle that). I think the cost issue is a moot point (over the course of a project, the difference between free and $5-10k/proc for a MS-SQL unlimited license), especially when you factor in *moving* to MySQL from MS-SQL and the related training and productivity costs. But if you're thinking of scaling out or distributing/selling an application, it's a lot easier to pay $495/server (for the optional commercial, supported license of MySQL) thatn $5k+/processor for MS-SQL. Of course there's other open source options like Firebird and Derby (formerly IBM Cloudscape) that are interesting to use as well -- John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195403 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL charging hard?
Different applications require different databases. Each databse has it perks and failures, depends on what you need. I would guess that Oracle is over kill for most web apps. For that matter SQL2K, DB2 and informix maybe as well. MySql is free but it has it's draw backs, i.e. no stored procedures and I believe therie is SQL nesting incapabilities as well. Like I said it is up to whomever to decide your database needs and I believe in using the best product for the project. -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Friday, February 18, 2005 10:55 AM To: CF-Talk Subject: Re: MySQL charging hard? On Fri, 18 Feb 2005 10:34:31 -0500, Rick Root [EMAIL PROTECTED] wrote: Eric Creese wrote: Does not sound as if you Oracle tunned properly and being that you do not have DBA on staff that can make it challenging. With it tunned properly it runs great in my oppinion. Plus your applications may not be tunned properly either. I also Run SQL2K and it has its benefits as well. Dabbled little with MySql. Basically it comes down to what is best or the job and what it is you are willing to support I don't doubt that Oracle can be very very fast. I even went to a week long oracle performance tuning class (taught by an Oracle employee, at an Oracle facility in Reston), but it was all just way too complicated. MySQL can also be *extremely* fast -- depending on how well you've tuned it and your specific needs. One really great part of MySQL is that each table can use a different handler, and the MyISAM tables are *very* fast for indexed reads and many inserts. Since they are *not* transaction safe, they don't have all the overhead of MS-SQL, Oracle, PostgreSQL, etc when you don't need that overhead (data warehousing for example). I just rewrote the training materials for MySQL's week-long MySQL intro course, which includes about 1.5 days on tuning. For many types of web applications MySQL properly tuned can easily compete with Oracle -- there's several presentations coming up at the MySQL Users Conf in April on multi-terabyte MySQL database projects... I bet if we had a DBA on staff, we'd be sticking with Oracle =) One thing about MS-SQL that's great is that it works really well *out of the box*. MySQL and Oracle out of the box may or may not be tuned properly. Simply enabling the query cache in MySQL 4.1+ can provide a drastic improvement in applications that do a lot of repeated read (blog, content delivery sites, catalogs) but you have to know about it. - Rick -- John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195404 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
MySQL charging hard?
What does everyone think about this? I used MySQL until I started using SP's. Then I HAD to go with SQL Server for my needs. What will this mean for the db market? http://www.crn.com/sections/breakingnews/dailyarchives.jhtml;jsessionid=KNGJNLFGHQAMAQSNDBGCKHSCJUMEKJVN?articleId=60401366 Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195327 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL charging hard?
From: Will Tomlinson [mailto:[EMAIL PROTECTED] What does everyone think about this? I used MySQL until I started using SP's. Then I HAD to go with SQL Server for my needs. What will this mean for the db market? Will, I used to be a die hard SQL Server fan forever and ever always avoiding MySQL and Oracle until I needed to buy hosting myself and was a little weary of paying for SQL Server for a blog! So I took the plunge and went with MySQL. To be honest, I love it. I think as more features come out (hopefully at a quicker pace) the more MySQL will catch on. It already has a huge following, I was just so stuck on MS SQL Server that I didn't see it. Anyway, it will be interesting to see what format/syntax the stored procedures will take on as well as the triggers (Jochem, any insight??). I really enjoy the power and benefits from both the features in SQL Server so they will be a very nice addition to MySQL. Mike ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195328 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL charging hard?
Will Tomlinson wrote: What does everyone think about this? I used MySQL until I started using SP's. Then I HAD to go with SQL Server for my needs. What will this mean for the db market? In my department at Duke, we have databases in MySQL 4.1 and Oracle 9. I've found Oracle to be exceptionally difficult to maintain, since I'm not a DBA. MySQL is much easier. However, we've done some performance testing, pitting Oracle against MySQL and SQL Server... and we found that SQL Server - on a smaller machine - actually performed faster than both MySQL and Oracle. MySQL was good when small amounts of data were returned versus Oracle, but SQL Server was faster pretty much across the board. SQL Server is also easier to maintain. I like MySQL, and I will continue to use it for pretty much all of my freelance web development, unless my clients desire otherwise. But in our department at Duke, where we're dealing with very large datasets (millions of rows in several tables), we're going with SQL Server (ie, we're going to phase out Oracle *AND MySQL and switch to SQL Server, even though Oracle is free for us, and SQL Server is not.) - Rick -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 2/14/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195332 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL charging hard?
yeah, I had a blast with MySQL back when I used it. It's pretty much what I learned on, and worked really well! Cheated with Navicat, so that made things much more pleasant as well. I like my GUI's! Is that such a bad thing? Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195333 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54