MySQL 5.1 to be 20% faster - GoFuckYourself.com

brandonstills · 04-12-2008, 03:10 PM

I totally forgot about Sun acquiring MySQL. Anybody else remember that?

The article claims MySQL 5.1 is supposedly 20% faster. It also claims better support for transactions and more enterprisy features. It also says some things will be faster some slower. Makes me wonder faster for who? Most of the stuff us webmasters use for DB work is not all that complicated or advanced as far as database features. Usually the more complicated a program gets the slower it gets.

http://www.cio.com/article/333613/Su...rade_Next_Week

nnweb · 04-12-2008, 05:44 PM

mysql sucks. they just barely added stored procs.

im all about sql server! the BEST out of the box database server hands down.

Iron Fist · 04-12-2008, 05:45 PM

Quote:

Originally Posted by nnweb

mysql sucks. they just barely added stored procs.

im all about sql server! the BEST out of the box database server hands down.

What they said...

PornGeneral · 04-12-2008, 06:04 PM

For most adult related work a MySQL 5+ server properly managed with good written code/queries will be just fine. IMHO

farkedup · 04-12-2008, 06:41 PM

I cache all of my most common queries into flat files, use MySQL for the easy administration aspects while having files as close to static as possible

brandonstills · 04-12-2008, 07:22 PM

I'm still waiting for OODBMS's to pick up. RDBMS are so dated and take so much more time to develop with.

mrkris · 04-12-2008, 07:36 PM

Mysql is fine for the most part. It's the developers who don't know about caching that causes problems ...

** looks at WordPress -- How many queries is it up to now for front page on default install?

TidalWave · 04-12-2008, 08:09 PM

Quote:

Originally Posted by brandonstills

I totally forgot about Sun acquiring MySQL. Anybody else remember that?

The article claims MySQL 5.1 is supposedly 20% faster. It also claims better support for transactions and more enterprisy features. It also says some things will be faster some slower. Makes me wonder faster for who? Most of the stuff us webmasters use for DB work is not all that complicated or advanced as far as database features. Usually the more complicated a program gets the slower it gets.

http://www.cio.com/article/333613/Su...rade_Next_Week

it doesnt say slower than it is now, it says 20% is average performance increase though some aspects may have less than 20%, some may have more.
Not at all saying slower than currently.

dooglas · 04-12-2008, 08:17 PM

Quote:

Originally Posted by brandonstills

I'm still waiting for OODBMS's to pick up. RDBMS are so dated and take so much more time to develop with.

I'll second that!

tiger · 04-13-2008, 12:15 AM

Quote:

Originally Posted by mrkris

Mysql is fine for the most part. It's the developers who don't know about caching that causes problems ...

** looks at WordPress -- How many queries is it up to now for front page on default install?

Yeah no shit. I just noticed I had one auto feed wordpress blog that was so fucked up it was brining a dual quad core with 8 gigs of ram to its knees.

mike-al · 04-13-2008, 12:17 AM

Quote:

Originally Posted by brandonstills

I totally forgot about Sun acquiring MySQL. Anybody else remember that?

The article claims MySQL 5.1 is supposedly 20% faster. It also claims better support for transactions and more enterprisy features. It also says some things will be faster some slower. Makes me wonder faster for who? Most of the stuff us webmasters use for DB work is not all that complicated or advanced as far as database features. Usually the more complicated a program gets the slower it gets.

http://www.cio.com/article/333613/Su...rade_Next_Week

They forgot to mention the cpu's are twice as powerful now :p

GrouchyAdmin · 04-13-2008, 12:20 AM

Quote:

Originally Posted by mrkris

Mysql is fine for the most part. It's the developers who don't know about caching that causes problems ...

** looks at WordPress -- How many queries is it up to now for front page on default install?

That's one bit. It's free, it's simple, it does simple things, and lets idiots do dumb things.

You should know about WP. Last I checked it was 8. That's when I dismissed it. Shit, not even some homebrew hack by the uninitiated (usually) takes that much.

04-12-2008, 03:10 PM	#1
brandonstills Confirmed User Join Date: Dec 2007 Location: Chatsworth, CA Posts: 1,964	MySQL 5.1 to be 20% faster I totally forgot about Sun acquiring MySQL. Anybody else remember that? The article claims MySQL 5.1 is supposedly 20% faster. It also claims better support for transactions and more enterprisy features. It also says some things will be faster some slower. Makes me wonder faster for who? Most of the stuff us webmasters use for DB work is not all that complicated or advanced as far as database features. Usually the more complicated a program gets the slower it gets. http://www.cio.com/article/333613/Su...rade_Next_Week __________________ Brandon Stills Industry and programming veteran [email protected] \| skype: brandonstills \| ICQ #495-171-318

04-12-2008, 05:44 PM	#2
nnweb Confirmed User Industry Role: Join Date: Apr 2004 Location: OC Posts: 720	mysql sucks. they just barely added stored procs. im all about sql server! the BEST out of the box database server hands down. __________________ ONLYFANS MANAGEMENT \| ONLYFANS MODEL SEARCH

04-12-2008, 06:04 PM	#4
PornGeneral Confirmed User Join Date: Sep 2004 Location: In front of computer Posts: 564	For most adult related work a MySQL 5+ server properly managed with good written code/queries will be just fine. IMHO __________________ "The object of war is not to die for your country but to make the other bastard die for his." -Patton "Only the dead have seen the end of war." -Plato

04-12-2008, 06:41 PM	#5
farkedup Confirmed User Join Date: Nov 2007 Location: Kalamazoo, MI Posts: 2,490	I cache all of my most common queries into flat files, use MySQL for the easy administration aspects while having files as close to static as possible __________________ -- QUOTE ME IT MAKES ME FEEL SPECIAL --

04-12-2008, 07:22 PM	#6
brandonstills Confirmed User Join Date: Dec 2007 Location: Chatsworth, CA Posts: 1,964	I'm still waiting for OODBMS's to pick up. RDBMS are so dated and take so much more time to develop with. __________________ Brandon Stills Industry and programming veteran [email protected] \| skype: brandonstills \| ICQ #495-171-318

04-12-2008, 07:36 PM	#7
mrkris Confirmed User Join Date: May 2005 Posts: 2,737	Mysql is fine for the most part. It's the developers who don't know about caching that causes problems ... ** looks at WordPress -- How many queries is it up to now for front page on default install? __________________ PHP-MySQL-Rails \| ICQ: 342500546