""Paul Schmidt"" <paul@...> wrote in message
news:3BFD0003.31361.365E11@localhost...

>
> What is meant by the term ACID, and how is that different from the
> IB/FB we all know and love?

ACID == concentrated vitriol. :-)

Well, in dbs it means atomicity, consistency, isolation & durability.
http://odbmsfacts.com/articles/acid_properties.html

> I realise I am opening a can of small slithering hermaphrodite
> vegetarians here,

Why do you need to use such a complex term for a plain snail, are you a
zoologist?
:-)

> but I have heard the term a number of times, but
> nobody has explained it,

The term is not related to a MS technology. It's a concept about
requirements that a db engine should fulfil.

> other then that is the reason that MS-SQL
> (and I suppose the Sybase V10 it was hacked from) has the
> amazing ability to turn a 2GHz P4 into an XT.

Maybe because, same as Windoze, it takes thrice the resources in the machine
and asks for more. In contrast, Jim said that IB was happy with 16 MB as
much, so it means we have the opposite problem: IB/FB doesn't know what to
do with big amounts of RAM.

And now, can we continue discussing snails, please?
<g>

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing