Re: MySQL [was: Re: Dr. Miguel 'Optimistic Locking' Arroz [was Re: WebObjects stress Testing tool?]]
Re: MySQL [was: Re: Dr. Miguel 'Optimistic Locking' Arroz [was Re: WebObjects stress Testing tool?]]
- Subject: Re: MySQL [was: Re: Dr. Miguel 'Optimistic Locking' Arroz [was Re: WebObjects stress Testing tool?]]
- From: Chuck Hill <email@hidden>
- Date: Fri, 4 Dec 2009 20:54:34 -0800
On Dec 4, 2009, at 7:07 PM, Guido Neitzer wrote:
On 4. Dec. 2009, at 17:46 , Mike Schrag wrote:
That's what I'm referring ... I have not used it, only read about
it enough to be intrigued by it. It requires your entire database
to be loaded into memory, but memory is pretty damn cheap. If you
have a truly HUGE database, this is not an option, but most of ours
are not larger than the reasonable max amount of memory.
Personally I have only fairly small databases - big tables being in
the couple hundred thousand rows range. Professionally, it's a
different thing. Big table in the couple billion rows tables.
Yeah, I think a couple billion rows qualifies as "big" in general
database terms. :-P
Oracle's a weird cat ... On the one hand, it his this weird pile of
ancient restrictions (31 char column name limits, etc). On the
other hand, it's insanely fast. I don't have real scientific
comparisons to back this up, but anecdotally, it's fast as hell.
Yeah, it's really weird. When I used it, I found it pretty
cumbersome. Which might have to do with the fact that with the
license cost, normally a DBA comes within the box ... so they don't
really care about making it usable for mere mortals.
That was my big grumble against it, until they started revising the
licensing terms. It can be seriously annoying to admin. It can pick
up and MOVE when tuned correctly.
Chuck
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden