From 18b93f656402d4994e8bfd195984e44d12c62765 Mon Sep 17 00:00:00 2001
From: prabatuty <prabatuty>
Date: Mon, 12 Oct 2009 13:12:52 +0000
Subject: [PATCH] adding flush cache statement

---
 demo/wisc/JDBCBench.java | 6 ++++++
 demo/wisc/odbcBench.c    | 9 +++++++++
 2 files changed, 15 insertions(+)

diff --git a/demo/wisc/JDBCBench.java b/demo/wisc/JDBCBench.java
index 7f867ac6..300c94f5 100644
--- a/demo/wisc/JDBCBench.java
+++ b/demo/wisc/JDBCBench.java
@@ -282,6 +282,8 @@ public static void main(String[] args)
 	      cStmt.close();
 	      cStmt.execute("CREATE INDEX idx4 ON big1(stringu1) HASH");
 	      cStmt.close();
+              cStmt.execute("FLUSH CACHE");
+	      cStmt.close();
               con.commit();
           }catch(Exception e ){e.printStackTrace(); System.out.println("Error creating index");}
 	  timeTaken[0][1] = singleTuple(con, true);
@@ -309,6 +311,8 @@ public static void main(String[] args)
 	      cStmt.execute("CREATE INDEX idx6 ON big2(unique1) TREE");
 	      cStmt.execute("CREATE INDEX idx7 ON small(unique1) TREE");
 	      cStmt.execute("CREATE INDEX idx8 ON big1(stringu1) TREE");
+              cStmt.execute("FLUSH CACHE");
+	      cStmt.close();
               con.commit();
           }catch(Exception e ){e.printStackTrace(); System.out.println("Error creating index");}
 
@@ -335,6 +339,8 @@ public static void main(String[] args)
 	      cStmt.close();
 	      cStmt.execute("DROP INDEX idx8;");
 	      cStmt.close();
+              cStmt.execute("FLUSH CACHE");
+	      cStmt.close();
               con.commit();
           }catch(Exception e ){System.out.println("Error dropping indexes");}
 
diff --git a/demo/wisc/odbcBench.c b/demo/wisc/odbcBench.c
index 62f48c6f..1c32b630 100644
--- a/demo/wisc/odbcBench.c
+++ b/demo/wisc/odbcBench.c
@@ -101,6 +101,9 @@ void createHashIndex(SQLHANDLE hstmt,bool flag)
     checkrc (rc, __LINE__);
     rc = SQLExecDirect(hstmt, (SQLCHAR*) "CREATE INDEX idx4 ON big1(stringu1) HASH", SQL_NTS );
     checkrc (rc, __LINE__);
+    rc = SQLExecDirect(hstmt, (SQLCHAR*) "FLUSH CACHE", SQL_NTS );
+      checkrc (rc, __LINE__);
+
     return;
 }
 void createTreeIndex(SQLHANDLE hstmt,bool flag)
@@ -114,6 +117,8 @@ void createTreeIndex(SQLHANDLE hstmt,bool flag)
     checkrc (rc, __LINE__);
     rc = SQLExecDirect(hstmt, (SQLCHAR*) "CREATE INDEX idx8 ON big1(stringu1) TREE;", SQL_NTS );
     checkrc (rc, __LINE__);
+    rc = SQLExecDirect(hstmt, (SQLCHAR*) "FLUSH CACHE", SQL_NTS );
+    checkrc (rc, __LINE__);
     return;
 }
 void dropHashIndex(SQLHANDLE hstmt,bool flag)
@@ -127,6 +132,8 @@ void dropHashIndex(SQLHANDLE hstmt,bool flag)
     checkrc (rc, __LINE__);
     rc = SQLExecDirect(hstmt, (SQLCHAR*) "DROP INDEX idx4 ;", SQL_NTS );
     checkrc (rc, __LINE__);
+    rc = SQLExecDirect(hstmt, (SQLCHAR*) "FLUSH CACHE", SQL_NTS );
+    checkrc (rc, __LINE__);
     return;
 }
 void dropTreeIndex(SQLHANDLE hstmt,bool flag)
@@ -140,6 +147,8 @@ void dropTreeIndex(SQLHANDLE hstmt,bool flag)
     checkrc (rc, __LINE__);
     rc = SQLExecDirect(hstmt, (SQLCHAR*) "DROP INDEX idx8 ;", SQL_NTS );
     checkrc (rc, __LINE__);
+    rc = SQLExecDirect(hstmt, (SQLCHAR*) "FLUSH CACHE", SQL_NTS );
+    checkrc (rc, __LINE__);
     return;
 }
 
-- 
2.11.4.GIT