[CentOS] Centos/Linux Disk Caching, might be OT in some ways

Ross Walker rswwalker at gmail.com
Tue Jan 26 14:48:36 UTC 2010


On Jan 26, 2010, at 2:30 AM, JohnS <jses27 at gmail.com> wrote:

>
> On Tue, 2010-01-26 at 13:41 +0800, Christopher Chan wrote:
>> JohnS wrote:
>>> On Tue, 2010-01-26 at 08:19 +0800, Christopher Chan wrote:
>>>> Are complicated relationships being stored in postgresql and not in
>>>> mysql? I do not know how things are now but mysql has a history  
>>>> of only
>>>> being good for simple selects.
>>>
>>> Selects can get very upity for mysql as in "VIEWS".  They can do  
>>> Concat,
>>> Inner Join and Outter among many more things.  VIEW myview as  
>>> SELECT can
>>> do some very very logical calcs and predictions.  I promise it is  
>>> not
>>> just for simple selects.
>>>
>>
>> By 'being good only for simple selects' I meant performance wise.  
>> Which
>> is what this thread is all about - performance. Sure you can make
>> complicated queries on mysql but compared to postgresql they would  
>> take
>> quite some time. Again, this is based on stuff in the past. Maybe  
>> mysql
>> has improved now.
>
> Sure, I knew what you meant, but we gonna Bang Heads on your  
> definition
> of simple selects.  I can't compare performance to postgresql but I am
> willing to bet that mysql can do alot more.  Doing something like a
> "Breadth First" or "Depth First" logical operation, it is sad for me  
> to
> even say MySQL is faster in that area with predictions than MSSQL.
> Having said that I really love mssql and sqlce. Now we getting OT.
>
> Great things started to happen with mysql @ version 5 >.  Now it's  
> just
> probally going to wither away.  Who really knows?

Some really nice things are happening with postgresql as well, you  
should check it out.

-Ross




More information about the CentOS mailing list