Author: myrnavl
Date: Sun May 27 19:20:25 2007
New Revision: 542080
URL: http://svn.apache.org/viewvc?view=rev&rev=542080
Log:
DERBY-1797 - Building toursdb would go a little faster if it used autocommit off. Patch contributed
by James F. Adams.
Modified:
db/derby/code/trunk/java/demo/toursdb/ToursDB_schema.sql
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/checkToursDB.out
Modified: db/derby/code/trunk/java/demo/toursdb/ToursDB_schema.sql
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/toursdb/ToursDB_schema.sql?view=diff&rev=542080&r1=542079&r2=542080
==============================================================================
--- db/derby/code/trunk/java/demo/toursdb/ToursDB_schema.sql (original)
+++ db/derby/code/trunk/java/demo/toursdb/ToursDB_schema.sql Sun May 27 19:20:25 2007
@@ -13,6 +13,8 @@
-- See the License for the specific language governing permissions and
-- limitations under the License.
+AUTOCOMMIT OFF;
+
CREATE TABLE AIRLINES
(
AIRLINE CHAR(2) NOT NULL ,
@@ -179,3 +181,4 @@
CREATE TRIGGER TRIG2 AFTER DELETE ON FLIGHTS FOR EACH STATEMENT
INSERT INTO FLIGHTS_HISTORY (STATUS) VALUES ('INSERTED FROM TRIG2');
+COMMIT;
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/checkToursDB.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/checkToursDB.out?view=diff&rev=542080&r1=542079&r2=542080
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/checkToursDB.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/checkToursDB.out
Sun May 27 19:20:25 2007
@@ -14,7 +14,8 @@
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.
-CREATE TABLE AIRLINES
+AUTOCOMMIT OFF;
+ij> CREATE TABLE AIRLINES
(
AIRLINE CHAR(2) NOT NULL ,
AIRLINE_FULL VARCHAR(24),
@@ -161,6 +162,7 @@
ij> CREATE TRIGGER TRIG2 AFTER DELETE ON FLIGHTS FOR EACH STATEMENT
INSERT INTO FLIGHTS_HISTORY (STATUS) VALUES ('INSERTED FROM TRIG2');
0 rows inserted/updated/deleted
+ij> COMMIT;
ij> ij version 10.3
WARNING 01J01: Database 'toursDB' not created, connection made to existing database instead.
CONNECTION0* - jdbc:derby:toursDB
|