> Maybe one of the 2000 is a querry optimiser? Or one of the "many things"
it
OK accepted, perhaps sub queries make things faster.
Is it because the result set doesnt have to travel back and forth from
application to db server again and again ?
Do triggers, trans, foreign keys and rest 1996 things etc also improve speed
?
So, apart from sub-queries for everything else MySQL is faster. is it ?
Does orcale store its DB files the same way as MySQL, I mean in SQL query
dumps. or does it compress/encrypt it and then store it ?
> supports is better memory management?
Obivously, if you have "many other things" to handle you need better
management to stay afloat, how does that "improve" ***speed*** ?
The shortest road between two points is a straight line.The person driving
on the zig-zag road will always loose.
Even if he is a much better driver, he has those extra turns to handle too.
He can never beat the straight road driver on the same hardware. Even if the
hardware load is a Truck or a mofa. ;o)
overall, you dig what I am trying to say ?
Apart from sub-queries(that too in some cases), MySQL should perform better,
cause it travels on the straghter road.
================================================
To subscribe, send email to [EMAIL PROTECTED] with subscribe in subject header
To unsubscribe, send email to [EMAIL PROTECTED] with unsubscribe in subject header
Archives are available at http://www.mail-archive.com/ilugd%40wpaa.org
=================================================
