Re: Problem with Sequences in SQL Load

From: <billmil_at_my-deja.com>
Date: Mon, 18 Dec 2000 18:00:23 GMT
Message-ID: <91ljbj$17c$1_at_nnrp1.deja.com>


> Why don't you just write your user activity directly to the database
> from the web app?

In theory, for performance reasons. We thought (perhaps incorrectly) that writing to a flat file would be much quicker than writing to a database table. (We do a lot of database io on our home page, particularly, so we're trying to keep database to the minimum). We don't need the results immediately and import the tables during lowactivity  periods.

>I am also unclear as to why you would have
> chosen to define your uniquely genereated id's as alpha.
We created in our data modeling tool a "_id" domain (10 character alpha). We use this domain for all our sequence-generated unique keys.

> If you
> have to process a flat file, another approach may be to write a
> procedure to load it. I would use a sequence in this case as well.
This makes sense. We use sql loader because of its convenience, though writing an import program wouldn't be hard.

Thanks for the input.

bill milbratz

Sent via Deja.com
http://www.deja.com/ Received on Mon Dec 18 2000 - 19:00:23 CET

Original text of this message