Hi,
> Do triggers, trans, foreign keys and rest 1996 things etc also improve
speed
> ?
a lot of things improve performence, if used properly! Transactions are
something that u need for a lot of applications, and they are also supported
by MySQL in some table types ;)
> So, apart from sub-queries for everything else MySQL is faster. is it ?
Another way in which oracle can get extremely fast is when u use stored
procedures. in fact i hav yet to see any decent *oracle/(your favourite
commercial RDBMS here)* app that doesn't make use of stored procedures.
Stored procedures improve performence by a big margin.
> 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 ?
oracle and mysql hav different physical storage formats. And with mysql u
have a choice of table types where the storage format and access speed is
different across different table types.
> > 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*** ?
better memory management does make a big difference.
> 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 ?
This is totally flawed logic. I won't go into details, but i feel that u
shud study more abt application optimizations. There are 100s of examples
where a complicated algorithm is significantly faster than a simple
algorithm. One example is in sorting.. everyone knows that bubble sort is
one of the simplest algorithms, but we also know that it is one of the
slowest algo too. Simple does not equal fast/optimized.
>
> Apart from sub-queries(that too in some cases), MySQL should perform
better,
> cause it travels on the straghter road.
not nescessarily.. things like memory management and caching can make a big
difference. Also mysql itself has various table types, of which some perform
much faster than others in the same hardware.
Bye,
/\ |\/| |3 /\ r
================================================
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
=================================================
