From b9690972d084c09f5cc080322db29c54be872045 Mon Sep 17 00:00:00 2001 From: Dan McGee Date: Tue, 1 Mar 2011 09:58:09 -0600 Subject: Use a single transaction to write dummy data This is immensely faster when using InnoDB since we don't need to sync after each and every INSERT statement. Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer --- support/schema/gendummydata.py | 2 ++ 1 file changed, 2 insertions(+) (limited to 'support/schema') diff --git a/support/schema/gendummydata.py b/support/schema/gendummydata.py index 090aabb..d51b16c 100755 --- a/support/schema/gendummydata.py +++ b/support/schema/gendummydata.py @@ -54,6 +54,7 @@ if len(sys.argv) != 2: # Just let python throw the errors if any happen # out = open(sys.argv[1], "w") +out.write("BEGIN;\n") # make sure the seed file exists # @@ -313,6 +314,7 @@ for p in seen_pkgs.keys(): # close output file # +out.write("COMMIT;\n") out.write("\n") out.close() -- cgit v1.2.3-70-g09d2