Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
That works OK, but I think it's actually doing an insert and commit for every record because it takes quite a while(one record every 1-4 seconds, >300,000 records). I'm looking into transactions with only one commit, but I'm not sure how much faster it would work. I'm trying to get something faster than the native(Ingres) "copy to flat file" and the native(Oracle) "copy into table from flat file". So far, appending is the simplest choice, but the slowest. Thanx though.
>Don't know if this would be the fastest way but my first try would be:
>
>select rvView1
>append from dbf(rvView2)
>
>Gerry
>
>
>
.Signature
{
margin-top: 12px;
color: #666666;
}
.Signature a
{
color: #666666;
}
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement