On Mon, 13 Mar 2000, Orlando Andico wrote:
> On Sun, 12 Mar 2000, Brian Baquiran wrote:
> ..
> > For simple table lookups, however, it is very, very fast. Probably several
> > orders of magnitude faster than Oracle or MS SQL.
>
> I wouldn't say that. A properly-tuned Oracle configuration is as fast or
> faster than MySQL on single-table queries. At least, in my experience. Of
> course, getting Oracle "properly tuned" basically means throwing lots of
> hardware at it.
I should have added "on equivalent hardware".
> Our production system here in MosCom has 2GB of memory,
> which helps A LOT in speeding up those queries :)
Yes it would, particularly if you have the entire dataset in memory.
Brian
--
[EMAIL PROTECTED]
http://www.baquiran.com
AIM: bbaquiran
-
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
