Update of /cvsroot/monetdb/sql/src/benchmarks/ATIS/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv23009/src/benchmarks/ATIS/Tests
Modified Files:
load.stable.out
Log Message:
Many fixes
changed how we handle selections over multiple columns of a single table
(should solve the preformance problem reported by Venks)
added a way to bulk request sequence numbers. When loading (copying) data
into tables which have a auto_increment (or alike) column lots of time
was spend in the many calls to get all the sequence numbers (observed a
performance in crease of about 10x when loading pieces of 100K rows)
added support for TINYINT (we map this too 'bte')
improved mapping functions onto the same signature too improve cached
function reuse
Index: load.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/ATIS/Tests/load.stable.out,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -d -r1.11 -r1.12
--- load.stable.out 27 Oct 2006 18:23:50 -0000 1.11
+++ load.stable.out 29 Jun 2007 11:28:47 -0000 1.12
@@ -19588,7 +19588,7 @@
% .qc, .qc # table_name
% query, count # name
% clob, int # type
-% 164, 4 # length
+% 162, 4 # length
[ "select * from query_cache() qc;", 1 ]
[ "insert into transport values (\\'L\\',\\'LIMOUSINE\\');", 4 ]
[ "insert into time_zone values (\\'HST\\',\\'HAWAII/ALEUTIAN STANDARD
TIME\\');", 9 ]
@@ -19599,20 +19599,13 @@
[ "insert into restrict_carrier values (\\'AP/1\\',\\'AA\\');", 612
]
[ "insert into month_name values (1,\\'JANUARY\\');", 12 ]
[ "insert into time_interval values (\\'morning\\',0000,1200);", 12
]
-[ "insert into ground_service values (\\'WWAS\\',\\'BWI\\',\\'L\\',12.00);",
2 ]
-[ "insert into ground_service values (\\'PPIT\\',\\'PIT\\',\\'L\\',7.50);",
2 ]
-[ "insert into ground_service values (\\'PPHL\\',\\'PHL\\',\\'L\\',4.75);",
1 ]
-[ "insert into ground_service values (\\'MATL\\',\\'ATL\\',\\'R\\',0.00);",
20 ]
-[ "insert into ground_service values (\\'MATL\\',\\'ATL\\',\\'L\\',9.00);",
8 ]
+[ "insert into ground_service values (\\'MATL\\',\\'ATL\\',\\'L\\',9.00);",
33 ]
[ "insert into food_service values (\\'B\\',1,\\'FIRST\\',\\'BREAKFAST\\');",
121 ]
[ "insert into flight_fare values (101910,\\'7100001\\');", 2998 ]
[ "insert into flight_day values (\\'1234567\\',1,\\'MONDAY\\');", 448
]
[ "insert into flight_class values (101909,\\'FN\\');", 2895 ]
[ "insert into flight values
(101908,\\'1234567\\',\\'ATL\\',\\'BOS\\',636,1000,\\'DL\\',296,\\'FNYNBNMQ\\',\\'72S\\',\\'B\\',1,\\'N\\',204);",
579 ]
-[ "insert into fare values
(\\'7100019\\',\\'ATL\\',\\'DEN\\',\\'F\\',\\'UA\\',\\'\\',685.00,1370.00);",
289 ]
-[ "insert into fare values
(\\'7100009\\',\\'ATL\\',\\'BOS\\',\\'B\\',\\'\\',\\'VU/1\\',230.00,0.00);",
131 ]
-[ "insert into fare values
(\\'7100005\\',\\'ATL\\',\\'BOS\\',\\'K\\',\\'\\',\\'AP/57\\',0.00,388.00);",
106 ]
-[ "insert into fare values
(\\'7100001\\',\\'ATL\\',\\'BOS\\',\\'F\\',\\'\\',\\'\\',497.00,994.00);", 8
]
+[ "insert into fare values
(\\'7100001\\',\\'ATL\\',\\'BOS\\',\\'F\\',\\'\\',\\'\\',497.00,994.00);", 534
]
[ "insert into dual_carrier values (\\'AA\\',\\'AA\\',3000,5799,\\'AMERICAN
EAGLE\\');", 114 ]
[ "insert into day_name values (1,\\'MONDAY\\');", 7 ]
[ "insert into fconnection values
(312733,\\'ATL\\',\\'BOS\\',740,1127,\\'1234567\\',0,1,227);", 164 ]
@@ -19621,46 +19614,10 @@
[ "insert into code_description values (\\'-\\',\\'A DASH IN A DAY CODE
POSITION INDICATES NON-OPERATION ON THAT DAY\\');", 15 ]
[ "insert into class_of_service values (\\'R\\',1,\\'SUPERSONIC
AIRCRAFT\\');", 27 ]
[ "insert into city values
(\\'MATL\\',\\'ATLANTA\\',\\'GA\\',\\'USA\\',\\'EST\\');", 11 ]
-[ "insert into airport_service values (\\'\\',\\'\\',0.0,\\'\\',0);", 1
]
-[ "insert into airport_service values
(\\'DDEN\\',\\'DEN\\',6.5,\\'NE\\',30);", 1 ]
-[ "insert into airport_service values
(\\'DDFW\\',\\'DFW\\',13.0,\\'NW\\',70);", 10 ]
-[ "insert into airport_service values (\\'MATL\\',\\'ATL\\',9.0,\\'S\\',45);",
2 ]
+[ "insert into airport_service values (\\'MATL\\',\\'ATL\\',9.0,\\'S\\',45);",
14 ]
[ "insert into airport values (\\'ATL\\',\\'WILLIAM B.
HARTSFIELD\\',\\'ATLANTA,GEORGIA\\',\\'GA\\',\\'USA\\',\\'EST\\');", 9
]
[ "insert into airline values (\\'AA\\',\\'AMERICAN AIRLINES\\',\\'\\');",
314 ]
-[ "insert into aircraft values (\\'SA2\\',\\'SAUNDERS
ST-27\\',2,\\'TURBOPROP\\',\\'NO\\',71.50,59.00,13500,23,0,230,0,\\'NO\\');",
1 ]
-[ "insert into aircraft values (\\'MIH\\',\\'MIL
MI-8\\',2,\\'HELICOPTER\\',\\'NO\\',50.20,108.85,26455,28,0,140,311,\\'\\');",
1 ]
-[ "insert into aircraft values (\\'D95\\',\\'MCDONNELL DOUGLAS
DC9-50\\',2,\\'JET\\',\\'NO\\',93.25,133.41,12200,139,32615,593,2550,\\'YES\\');",
1 ]
-[ "insert into aircraft values (\\'DC6\\',\\'MCDONNELL DOUGLAS DC6 (ALL
SERIES)\\',4,\\'PROPELLER\\',\\'NO\\',117.50,101.50,93200,80,12310,309,3070,\\'YES\\');",
1 ]
-[ "insert into aircraft values (\\'DC4\\',\\'MCDONNELL DOUGLAS DOUGLAS
DC4/C-54 SKYMASTER
PASSENGER\\',4,\\'PROPELLER\\',\\'NO\\',117.50,93.91,73800,80,11440,230,2750,\\'NO\\');",
1 ]
-[ "insert into aircraft values (\\'DC3\\',\\'MCDONNELL DOUGLAS DC3/C47 DAKOTA
PASSENGER\\',2,\\'PROPELLER\\',\\'NO\\',95.00,64.50,25200,30,7380,207,1330,\\'NO\\');",
1 ]
-[ "insert into aircraft values (\\'L15\\',\\'LOCKHEED L1011-500
TRISTAR\\',3,\\'JET\\',\\'YES\\',155.33,164.20,496000,330,115000,580,5998,\\'YES\\');",
1 ]
-[ "insert into aircraft values (\\'LOM\\',\\'LOCKHEED L188 ELECTRA MIXED
CONFIGURATION\\',4,\\'TURBOPROP\\',\\'NO\\',99.00,104.50,116000,0,0,390,2200,\\'\\');",
1 ]
-[ "insert into aircraft values (\\'ILW\\',\\'ILYUSHIN
IL86\\',4,\\'JET\\',\\'YES\\',157.68,197.54,454152,350,0,575,0,\\'YES\\');",
2 ]
-[ "insert into aircraft values (\\'CVR\\',\\'CONVAIR (ALL
SERIES)\\',2,\\'TURBOPROP\\',\\'NO\\',105.33,79.16,54600,56,11200,350,1100,\\'YES\\');",
2 ]
-[ "insert into aircraft values (\\'CS2\\',\\'CASA C-212/NUSANTARA NC-212
AVIOCAR\\',2,\\'TURBOPROP\\',\\'NO\\',62.50,45.83,16427,28,6077,230,1400,\\'NO\\');",
2 ]
-[ "insert into aircraft values (\\'HS7\\',\\'BRITISH AEROSPACE (HAWKER
SIDDELEY) 748
PASSENGER\\',2,\\'TURBOPROP\\',\\'NO\\',98.50,67.00,46500,56,11363,275,850,\\'YES\\');",
1 ]
-[ "insert into aircraft values (\\'DHH\\',\\'BRITISH AEROSPACE (HAWKER
SIDDELEY)
HERON\\',4,\\'PROPELLER\\',\\'NO\\',71.50,48.50,13500,17,2100,195,0,\\'NO\\');",
2 ]
-[ "insert into aircraft values (\\'HPH\\',\\'BRITISH AEROSPACE (HANDLEY PAGE)
HERALD\\',2,\\'TURBOPROP\\',\\'NO\\',113.00,96.83,82000,74,12000,266,3150,\\'YES\\');",
3 ]
-[ "insert into aircraft values (\\'VCV\\',\\'BRITISH AEROSPACE (BAC-VICKERS)
VISCOUNT (ALL
SERIES)\\',4,\\'TURBOPROP\\',\\'NO\\',93.70,85.66,72500,75,14500,352,1725,\\'YES\\');",
1 ]
-[ "insert into aircraft values (\\'B11\\',\\'BRITISH AEROSPACE (BAC)
ONE-ELEVEN (ALL
SERIES)\\',2,\\'JET\\',\\'NO\\',88.50,93.50,78500,79,17600,550,1430,\\'YES\\');",
1 ]
-[ "insert into aircraft values (\\'757\\',\\'BOEING 757-200
PASSENGER\\',2,\\'JET\\',\\'NO\\',124.50,155.25,220000,224,38940,560,2440,\\'YES\\');",
2 ]
-[ "insert into aircraft values (\\'733\\',\\'BOEING
737-300\\',2,\\'JET\\',\\'NO\\',94.75,105.58,135000,138,35500,550,2500,\\'YES\\');",
1 ]
-[ "insert into aircraft values (\\'737\\',\\'BOEING 737 PASSENGER (ALL
SERIES)\\',2,\\'JET\\',\\'NO\\',93.00,94.00,111000,138,29093,577,1300,\\'YES\\');",
1 ]
-[ "insert into aircraft values (\\'72M\\',\\'BOEING 727-100C/100QC MIXED
CONFIGURATION\\',3,\\'JET\\',\\'NO\\',108.00,133.16,160000,96,30500,600,0,\\'YES\\');",
4 ]
-[ "insert into aircraft values (\\'727\\',\\'BOEING 727 PASSENGER (ALL
SERIES)\\',3,\\'JET\\',\\'NO\\',108.00,133.16,170000,131,35900,622,3000,\\'YES\\');",
4 ]
-[ "insert into aircraft values (\\'DH8\\',\\'BOEING CANADA DHC-8 DASH-8 (ALL
SERIES)\\',2,\\'TURBOPROP\\',\\'NO\\',84.00,75.00,0,32,0,300,691,\\'\\');",
3 ]
-[ "insert into aircraft values (\\'DH7\\',\\'BOEING CANADA DHC-7 DASH-7
PASSENGER\\',4,\\'TURBOPROP\\',\\'NO\\',93.00,80.58,43000,50,15000,275,850,\\'YES\\');",
1 ]
-[ "insert into aircraft values (\\'DHP\\',\\'BOEING CANADA DHC-2
BEAVER\\',1,\\'PROPELLER\\',\\'NO\\',48.00,30.25,5100,10,1800,143,733,\\'\\');",
10 ]
-[ "insert into aircraft values (\\'BEQ\\',\\'BEECHCRAFT QUEEN
AIR\\',2,\\'PROPELLER\\',\\'NO\\',50.25,35.50,8800,11,3578,214,1185,\\'NO\\');",
5 ]
-[ "insert into aircraft values (\\'BEB\\',\\'BEECHCRAFT
BARON\\',2,\\'PROPELLER\\',\\'NO\\',37.83,28.00,5120,6,1965,225,1085,\\'NO\\');",
4 ]
-[ "insert into aircraft values (\\'BEC\\',\\'BEECHCRAFT (ALL
SERIES)\\',2,\\'TURBOPROP\\',\\'NO\\',0.00,0.00,0,0,0,0,0,\\'NO\\');", 22
]
-[ "insert into aircraft values (\\'AN6\\',\\'ANTONOV AN26
FREIGHTER\\',2,\\'TURBOPROP\\',\\'NO\\',95.79,77.20,49297,50,0,280,342,\\'\\');",
1 ]
-[ "insert into aircraft values (\\'AN4\\',\\'ANTONOV
AN24\\',2,\\'TURBOPROP\\',\\'NO\\',95.83,77.25,42997,50,8150,295,807,\\'NO\\');",
9 ]
-[ "insert into aircraft values (\\'AB3\\',\\'AIRBUS INDUSTRIE (ALL
SERIES)\\',2,\\'JET\\',\\'YES\\',147.08,175.91,313060,345,68000,576,2100,\\'YES\\');",
15 ]
-[ "insert into aircraft values (\\'NDH\\',\\'AEROSPATIALE SA 365 DAUPHIN
2\\',1,\\'HELICOPTER\\',\\'NO\\',0.00,43.50,6615,14,0,196,423,\\'NO\\');", 1
]
-[ "insert into aircraft values (\\'CRV\\',\\'AEROSPATIALE CARAVELLE (ALL
SERIES)\\',2,\\'JET\\',\\'NO\\',112.50,118.83,127870,140,29100,512,2150,\\'YES\\');",
3 ]
-[ "insert into aircraft values (\\'SSC\\',\\'AEROSPATIALE-BRITISH AEROSPACE
(BAC)
CONCORDE\\',4,\\'JET\\',\\'NO\\',83.83,203.75,400000,128,25000,1400,3800,\\'YES\\');",
3 ]
-[ "insert into aircraft values (\\'ATR\\',\\'AEROSPATIALE/AERITALIA (ALL
SERIES)\\',2,\\'TURBOPROP\\',\\'NO\\',80.58,73.83,32446,49,10603,277,0,\\'YES\\');",
24 ]
+[ "insert into aircraft values (\\'ATR\\',\\'AEROSPATIALE/AERITALIA (ALL
SERIES)\\',2,\\'TURBOPROP\\',\\'NO\\',80.58,73.83,32446,49,10603,277,0,\\'YES\\');",
135 ]
# 10:34:16 >
# 10:34:16 > Done.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
