> > MySQL uses the simplest and most straight forward thread controls. It
has
> to
> > be faster ! Oracle should be slower!!
> > Oracle has probally 2000 extra things to protect oracle from crashing,
and
> > its programs are much larger than MySQL, since it is supposed to support
> too
> > many things, and take care of them !
>
> Maybe one of the 2000 is a querry optimiser? Or one of the "many things"
it
> supports is
> better memory management?
Last time i checked, MySQL didn't hav any built in caching algorithm. That
was 3.22.xx version series. For disk caching MySQL depends on the OS, and
AFAIK MySQL doesn't have any query cache or any query optimizer. These
things can increase the speed of the database by a big margin. Also sub
selects can improve performence in a big way too. Another thing that one
shud try is to use the innodb table sets. They are faster by a big margin.
The built in ISAM and myISAM tables are not as fast as the innodb tables.
Bye,
/\ |\/| |3 /\ r
PS: The performence of any database depends on a lot of things, and one of
them is the choices that are made in design stage and the way apps are
written, each db has different areas where they shine, and in my experience
MySQL is extremely fast for things like username lookup, and other simple
table lookup/insert operations.
================================================
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
=================================================
