Working like a MACHO man with MySQL

[Nostradamus]

Content removed, i don't want to share my knowleagement with some retarded staff.

 

[Slain]

owned..

maybe they forgot about researching mysql

good stuff.

 

[Nostradamus]

MySQL is coding, and MySQL is a programming language.

 

[Slain]

MySQL is coding, and MySQL is a programming language.

Hmm i probably should have stated it differently..corrected it.

 

[Kavvson]

Bit advanced but i face it

 

[Paxton]

Well I don't really see nothing bad with altering OT database structure

 

[hodleo]

man you're the god of otsql

 

[Lessaire]

Next you'll be suggesting people start using Percona too... my god. Or perhaps building a MySQL 5.5 dev snapshot.

 

[Nostradamus]

No, i will not. And i don't see the relationship of packages plus development stage versions and the SQL syntax. What are you trying to say exactly?

 

[Lessaire]

I was making a correlation on 'database performance.' to your opinions on the elementary query structure used by OT server webmasters and hobby coders writing PHP scripts. I would hope that was obvious, but apparently not.

btw(unrelated) the IRC client patch is good stuff. rep++

 

[Nostradamus]

It is not based on performance at all, it is about of beeing smart and write less code with more logic. That's why i've created this topic. To really good optimizations, there are a lot of technics NOT covered on this topic.

 

[WTF.Error]

ignore depot ?

 

[Pvls]

It is not based on performance at all, it is about of beeing smart and write less code with more logic. That's why i've created this topic. To really good optimizations, there are a lot of technics NOT covered on this topic.

But going this way of creating mysql function you not only shorten mysql query but also optimize respond times, so clearification of code and optimalization by the way.
Taking deeper inside, somethimes is better to not overengineer the code i mean if code looks better (is shorter) we are not sure that it will be working faster So there is no straight corelation between how code 'look likes' and code repond time - this shoudl be also included in first post.

Short example:

function shit ($string)
{
return ucword($string);
}

Maybe its funny, but im founding such a codes in almost every script/programm.