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

Home -> Community -> Usenet -> comp.databases.theory -> Re: Large dataset performance

Re: Large dataset performance

From: Cimode <cimode_at_hotmail.com>
Date: 21 Mar 2007 06:12:09 -0700
Message-ID: <1174482729.897956.292240@l75g2000hse.googlegroups.com>


On Mar 21, 1:42 pm, "Daniel" <danielapar..._at_gmail.com> wrote:
> The OP's problem seems to be to load 3.5 million rows into a table.
> You might want to explain to the OP how he could accomplish this more
> efficiently with a set operation, as opposed to performing inserts
> inside a loop, or using a bulk load utility. The OP is unlikely to be
> ab able to find this information in a book.
cdt is *not* an environment meant for discussing implementationdependent  issues but for discussing database theory and fundamentals. One must take into account that educating people online on SQL is neither efficient nor effective. OTOH, pointing out useful reading onto RM is efficient and effective into helping people, that *if* the OP seeks to understand what he/she is doing.

I take such realistic attitude not because I don't care but because anything else is a waste of time. For implementation dependent questions better use environments such as

http://www.experts-exchange.com

Regards... Received on Wed Mar 21 2007 - 08:12:09 CDT

Original text of this message

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