[an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive]
 
[an error occurred while processing this directive] [an error occurred while processing this directive]
Skåne Sjælland Linux User Group - http://www.sslug.dk Home   Subscribe   Mail Archive   Forum   Calendar   Search
MhonArc Date: [Date Prev] [Date Index] [Date Next]   Thread: [Date Prev] [Thread Index] [Date Next]   MhonArc
 

Re: [PROGRAMMERING] [SQL] Betinget INSERT?



-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sat, 28 Mar 2009 19:57:16 +0000 (UTC)
Troels Arvin <sslug@sslug> wrote:

> 
> OK. Men det er da lidt sært, ikke? - Altså at en kommando netop beregnet 
> til UPSERTs ikke skulle være en ret god fremgangsmåde. Nogle af 
> artiklerne som der henvises til, når man kigger på ovenstående og når man 
> googler er meget gamle. Kunne det tænkes, at nyere Oracle'er udfører det 
> mere effektivt?
> 
Jo, det virker sært, men måske skal problemet findes i, at en god plsql
programmør er bedre til at optimere end en generisk rutine i database
laget?

Jeg er dog blevet nysgerrig, så jeg har planer om at gentage de
beskrevne tests på vores 10.2 database på arbejdet. En anden
fremgangsmåde kunne også være bulk collect med forall konstruktionen
http://www.dba-oracle.com/oracle_news/news_plsql_forall_performance_insert.htm
Mere detaljeret gennemgang af Steven Feuerstein:
http://www.oracle.com/technology/oramag/oracle/08-mar/o28plsql.html

- -- 
Hilsen/Regards
Michael Rasmussen
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xE3E80917
A computer is like air conditioning: it becomes useless when you open
windows.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAknOhZ0ACgkQVErYVePoCRdN0gCcD4vk8iEzpHdKRxu2js0PFV27
FZ4An1gq4TMrU++TwGvS+cCJP6yX1md7
=DizF
-----END PGP SIGNATURE-----


 
Home   Subscribe   Mail Archive   Index   Calendar   Search

 
 
Questions about the web-pages to <www_admin>. Last modified 2009-04-01, 02:01 CEST [an error occurred while processing this directive]
This page is maintained by [an error occurred while processing this directive]MHonArc [an error occurred while processing this directive] # [an error occurred while processing this directive] *