Changeset 0691acd in tol

Timestamp:

Oct 26, 2008, 10:48:41 AM (18 years ago)

Author:

Víctor de Buen <vdebuen@…>

Branches:

1941-docker-image-to-test, devel, master

Children:

64e44a5

Parents:

1abcc87

Message:

Using new methods to handle with cached inserting queries to build optimized SQL scripts

git-svn-id: ​https://www.tol-project.org/svn/tolp/trunk@85 be4846ae-f051-483a-831f-b64e7d08527f

File:

• tol/stdlib/math/stat/models/bayesian/bysMcmc/bsr/dynhlm/_db_api.estim.tol (modified) (3 diffs)

tol/stdlib/math/stat/models/bayesian/bysMcmc/bsr/dynhlm/_db_api.estim.tol

@@ -20 +20 @@
   Set raftery_ = estim::report::coda.raftery.diag;
   Set raftery  = If(Card(raftery_)==Card(summary)+1, raftery_, Copy(Empty));
+  Real SqlStartCachedInsert(0);  
   Set For(1,Card(estim::report::coda.summary),Real save.param(Real k)
   {
@@ -32 +33 @@
       SetSum(For(4,Card(token),Text build.member(Real tk) 
       {"::"+token[tk]} )));
-    Real BysMcmc::Bsr::DynHlm::DBApi::SqlExecTrace(
-    "INSERT INTO "+dbName+"."+_table::ParamStats+"\n"
-    "VALUES('"+
+    Real BysMcmc::Bsr::DynHlm::DBApi::SqlCachedInsert(
+    dbName+"."+_table::ParamStats,
+    "'"+
      model+"','"+
      session+"','"+
@@ -57 +58 @@
      SqlFormatReal(cr->size.min_)+","<<
      SqlFormatReal(cr->dep.factor_)+","<<
-     SqlFormatReal(cr->remain_)+")" )
+     SqlFormatReal(cr->remain_))
   });
+  Real SqlStopCachedInsert(0);
   1
 };