Posted by Mladen Gogala on 06/07/05 02:36

On Sun, 05 Jun 2005 15:01:06 -0400, Gary L. Burnore wrote:

> Actually, "they" don't. Coding can be done so as to make use of the
> features of whichever database is used. Takes more up front planning,
> but it works.

Ah, that is so called "#ifdef portability". Yes, by using the sufficient
number of #ifdef or equivalents you can create a portable database
applications. The problem with the different databases is that they have
vastly diferent locking and optimization strategies and the methods of
controlling the optimizer or locking are very different. For instance, in
Oracle and UDB readers don't block writers. In MS-SQL, they do. That alone
is sufficient to make your application behave differently on MS-SQL and
UDB.

--
I either want less corruption, or more chance to participate in it.

[Back to original message]