Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Question about adding new record in table with primary key

Re: Question about adding new record in table with primary key

From: Gabriel Gonzalez <no-spam_at_no-spam.com>
Date: Thu, 6 Mar 2003 11:57:03 -0800
Message-ID: <eYecnRbKCLfgNfqjXTWciQ@giganews.com>


> Actually I didn't remember to tell that the problem
> should be solved without assumption of specific database.

Hmmm... I do not know if the SQL standard addresses this issue. I'd look at the standard if I was you... In my own experience creating applications that were to run on multiple databases, I ended up creating a slightly-modified version for each target database.

Accomplishing the same task in Oracle and, say, dBase (for a smaller installation) is vastly different, even if you can get drivers that work well. Plus, if you write a "generic" database definition, then you lose out on the many optimizations you can do, but are database-specific. For example, there's a lot of tweaking you can do with Oracle as far as storage goes... You can get great benefits in both space usage and execution speed if you adjust the storage settings for each table. All of those settings, though, are database specific.

Anyway, what I have ended up doing in the past is to target a very few databases (Access, Oracle, SQL Server, and dBase) and implement each with its own optimizations. Received on Thu Mar 06 2003 - 13:57:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US