----- Original Message -----
From: "amit soni" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, 02 May, 2002 1:56 AM
Subject: Re: [ilugd]: MySQL evaluation
>
> > 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
> ?
No idea, I do not do SQL, been 2 years since I saw Oracle, and use mySQL as
a store for stuff like horde, etc, where the "make install" sets everything
up. My point was not anything specific, just that there is too little data
to make a call here.
> So, apart from sub-queries for everything else MySQL is faster. is it ?
No idea what a sub-query is (would you use sup-SQL to select?)
> 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 ?
Compression sounds like a bad idea, except for something simple like RLE.
Performance would suffer with compression, I suppose.
> > 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)
Ah, you obviously prefer climbing up a wall, Spiderman. Me, I prefer to
zig-zag up the stairs (or take a lift, but that is another story). The
straight road is the brute force road, and is often a good
first-approximation to the solution. It is unlikely to be an optimal
solution. But the analogy breaks down pretty fast, so I will pass.
>
> 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.
Think: why do we zig-zag up a hill?
Again, I have no clue _why_ or even _if_ Oracle is "faster", just that the
simpler solution need not be the "better" solution.
--
Sanjeev
Linx MVP brainbench.com
================================================
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
=================================================
