Hi, sorry if i'm missing something
I try to run for example 18000 inserts. If i make it with FbBatchExecution,
it takes appr. 100 seconds
If i add the same 18000 rows to DataTable and then just save it with
FbDataAdapter.Update, it takes near 30 seconds. Is it normal behavior? I
thought, FbBatchExecution should be faster (or at least equal because, i
suppose, that DataAdapter also uses some sort of batch execution for
generated sql-statements).
The code for Batch is pretty simple
FbBatchExecution batch = new FbBatchExecution(FbConnection);
batch.SqlStatements.AddRange(ScriptBuilder.GetStatements());
batch.Execute(true); //the delay is really here, not
anywhere else
Test Table is also simple
CREATE TABLE AAA_1 (
ID INTEGER NOT NULL PRIMARY KEY,
TEXT VARCHAR(30),
DATUM DATE
);
My Provider version is 2.1.0.0, Firebird - superserver 2.0
--
View this message in context:
http://www.nabble.com/FbBatchExecution-VS-DataTable-tf3354120.html#a9328001
Sent from the firebird-net-provider mailing list archive at Nabble.com.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
