both have group by, here is sql select product_sk,sum(1) as recordcount from f_activity group by product_sk query:0.516 seconds select substring(fact_bk,1,1) as aa,sum(1) as recordcount from f_activity group by aa query:38.657 seconds 2012/7/27 Stefan Manegold

Hi,

does without substring() also mean without group by? (Since you group on the substring())

In other words, what is the exact query you run without substring that takes 1-3 seconds?

And: Could you run both queries prefixed with TRACE and share the profiling output?

Stefan

On Fri, Jul 27, 2012 at 08:41:43AM +0800, li, xiaohua wrote:

...

Hi all: we are testing monetdb on a sql

select substring(fact_bk,1,1) as aa,sum(1) as recordcount from f_activity group by aa the table f_activity have about 5 million rows. when i run this sql, monetdb need about 30 seconds . (if we use another no calculated column, it need only 1-3 seconds) when I run this sql on sql server, it needs only 7 seconds.

is monetdb not good at calculated column? or we have made some mistake?

please tell me the reason, thank you.

lixiaohua Shanghai,China

...

------------------------------------------------------------------------------

...

Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/

...

_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- 上海云数信息科技有限公司 http://www.cloudybi.com 联系人：李晓华 职务：总经理 手机：18616507502

Hi, the time mostly indeed goes into the substring calculation: $ sort -n nosubstring.csv | tail 149,"X_56=[7346898] := algebra.kdifference(X_52=nil:bat[:oid,:lng],X_54=:bat[:oid,:lng][0]);" 231,"X_58=[7346898] := algebra.kunion(X_56=nil,X_54=nil:bat[:oid,:lng]);" 403,"X_59=[7346898] := algebra.kdifference(X_57=nil,X_12=nil);" 3287,"(X_62=[21],X_63=[7346898]) := group.done(X_58=[7346898]);" 4479,"X_82=[7346898] := algebra.project(X_58=[7346898],A0=1:bte);" 5933,"X_80=[7346898] := algebra.project(X_59=[7346898],A0=1:bte);" 110078,"X_88=[21] := aggr.sum(X_84=nil,X_61=nil,X_66=nil);" 124961,"X_89=[21] := aggr.sum(X_85=nil,X_63=nil,X_69=nil);" 337295,"(X_60=[21],X_61=[7346898]) := group.done(X_59=[7346898]);" 487983,X_5:void := user.s147_1(1:bte); $ sort -n substring.csv | tail 40039,"X_96=[1] := aggr.sum(X_92=nil,X_71=nil,X_78=nil);" 50664,"(X_70=[1],X_71=[2673449]) := group.done(X_65=[2673449]);" 52755,"(X_67=[1],X_68=[2673449]) := group.done(X_64=[2673449]);" 87718,"X_95=[1] := aggr.sum(X_91=nil,X_68=nil,X_76=nil);" 101025,"X_87=[0] := algebra.join(X_17=[1],X_66=nil);" 102183,"X_94=[2] := mat.pack(X_95=nil,X_96=nil,X_97=nil);" 204422,"X_86=[0] := algebra.join(X_17=[1],X_65=nil);" 207690,"X_85=[1] := algebra.join(X_17=[1],X_64=nil);" 217476,"X_82=[2] := mat.pack(X_77=nil,X_79=nil,X_81=nil);" 33282589,"X_65=[2673449] := batstr.substring(X_62=[2673449],A0=1,A1=1);" With a brief look at the respective code, I cannot see and obvious reason for the time, respectively and obvoius way to improve it. Stefan On Fri, Jul 27, 2012 at 09:34:16AM +0800, li, xiaohua wrote:

here is the trace log

2012/7/27 Stefan Manegold

...

Hi,

does without substring() also mean without group by? (Since you group on the substring())

In other words, what is the exact query you run without substring that takes 1-3 seconds?

And: Could you run both queries prefixed with TRACE and share the profiling output?

Stefan

On Fri, Jul 27, 2012 at 08:41:43AM +0800, li, xiaohua wrote:

...

Hi all: we are testing monetdb on a sql

select substring(fact_bk,1,1) as aa,sum(1) as recordcount from f_activity group by aa the table f_activity have about 5 million rows. when i run this sql, monetdb need about 30 seconds . (if we use another no calculated column, it need only 1-3 seconds) when I run this sql on sql server, it needs only 7 seconds.

is monetdb not good at calculated column? or we have made some mistake?

please tell me the reason, thank you.

lixiaohua Shanghai,China

...

------------------------------------------------------------------------------

...

Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/

...

_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- 上海云数信息科技有限公司 http://www.cloudybi.com 联系人：李晓华 职务：总经理 手机：18616507502

ticks,stmt 10,"X_16 := nil:bat[:oid,:lng];" 9,"X_17:bat[:oid,:lng] := nil:bat[:oid,:lng];" 0,X_3 := sql.mvc(); 10,X_3 := sql.mvc(); 0,"X_48:bat[:oid,:lng] := sql.bind(X_3=0,""sys"",""f_activity"",""product_sk"",0,0,2);" 0,"X_9:bat[:oid,:lng] := sql.bind(X_3=0,""sys"",""f_activity"",""product_sk"",1);" 74,"X_9:bat[:oid,:lng] =[0] := sql.bind(X_3=0,""sys"",""f_activity"",""product_sk"",1);" 76,"X_48:bat[:oid,:lng] =[7346898] := sql.bind(X_3=0,""sys"",""f_activity"",""product_sk"",0,0,2);" 0,"(X_64,X_65) := group.done(X_9=:bat[:oid,:lng][0]);" 0,"X_83 := algebra.project(X_9=:bat[:oid,:lng][0],A0=1:bte);" 76,"X_83=[0] := algebra.project(X_9=:bat[:oid,:lng][0],A0=1:bte);" 82,"(X_64=[0],X_65=[0]) := group.done(X_9=:bat[:oid,:lng][0]);" 0,X_86 := algebra.selectNotNil(X_83=[0]); 0,X_72 := bat.mirror(X_64=[0]); 45,X_86=[0] := algebra.selectNotNil(X_83=nil); 93,X_72=[0] := bat.mirror(X_64=nil); 0,"X_54:bat[:oid,:lng] := sql.bind(X_3=0,""sys"",""f_activity"",""product_sk"",2,1,2);" 0,"X_74 := algebra.leftjoin(X_72=[0],X_9=:bat[:oid,:lng][0]);" 91,"X_74=[0] := algebra.leftjoin(X_72=[0],X_9=:bat[:oid,:lng][0]);" 105,"X_54:bat[:oid,:lng] =[0] := sql.bind(X_3=0,""sys"",""f_activity"",""product_sk"",2,1,2);" 0,"X_90 := aggr.sum(X_86=[0],X_65=[0],X_72=[0]);" 0,"X_52:bat[:oid,:lng] := sql.bind(X_3=0,""sys"",""f_activity"",""product_sk"",0,1,2);" 101,"X_52:bat[:oid,:lng] =[7346898] := sql.bind(X_3=0,""sys"",""f_activity"",""product_sk"",0,1,2);" 124,"X_90=[0] := aggr.sum(X_86=nil,X_65=nil,X_72=nil);" 0,"X_56 := algebra.kdifference(X_52=:bat[:oid,:lng][7346898],X_54=:bat[:oid,:lng][0]);" 0,"X_11:bat[:oid,:oid] := sql.bind_dbat(X_3=0,""sys"",""f_activity"",1);" 71,"X_11:bat[:oid,:oid] =[0] := sql.bind_dbat(X_3=0,""sys"",""f_activity"",1);" 149,"X_56=[7346898] := algebra.kdifference(X_52=nil:bat[:oid,:lng],X_54=:bat[:oid,:lng][0]);" 0,"X_12 := bat.reverse(X_11=:bat[:oid,:oid][0]);" 76,"X_12=[0] := bat.reverse(X_11=nil:bat[:oid,:oid]);" 0,"X_53:bat[:oid,:lng] := sql.bind(X_3=0,""sys"",""f_activity"",""product_sk"",2,0,2);" 0,"X_58 := algebra.kunion(X_56=[7346898],X_54=:bat[:oid,:lng][0]);" 60,"X_53:bat[:oid,:lng] =[0] := sql.bind(X_3=0,""sys"",""f_activity"",""product_sk"",2,0,2);" 231,"X_58=[7346898] := algebra.kunion(X_56=nil,X_54=nil:bat[:oid,:lng]);" 0,"X_55 := algebra.kdifference(X_48=:bat[:oid,:lng][7346898],X_53=:bat[:oid,:lng][0]);" 0,"(X_62,X_63) := group.done(X_58=[7346898]);" 142,"X_55=[7346898] := algebra.kdifference(X_48=nil:bat[:oid,:lng],X_53=:bat[:oid,:lng][0]);" 0,"X_57 := algebra.kunion(X_55=[7346898],X_53=:bat[:oid,:lng][0]);" 125,"X_57=[7346898] := algebra.kunion(X_55=nil,X_53=nil:bat[:oid,:lng]);" 0,"X_59 := algebra.kdifference(X_57=[7346898],X_12=[0]);" 403,"X_59=[7346898] := algebra.kdifference(X_57=nil,X_12=nil);" 0,"(X_60,X_61) := group.done(X_59=[7346898]);" 337295,"(X_60=[21],X_61=[7346898]) := group.done(X_59=[7346898]);" 0,X_66 := bat.mirror(X_60=[21]); 62,X_66=[21] := bat.mirror(X_60=nil); 0,"X_68 := algebra.leftjoin(X_66=[21],X_59=[7346898]);" 30,"X_68=[21] := algebra.leftjoin(X_66=[21],X_59=[7346898]);" 0,"X_80 := algebra.project(X_59=[7346898],A0=1:bte);" 5933,"X_80=[7346898] := algebra.project(X_59=[7346898],A0=1:bte);" 0,X_84 := algebra.selectNotNil(X_80=[7346898]); 10,X_84=[7346898] := algebra.selectNotNil(X_80=nil); 0,"X_88 := aggr.sum(X_84=[7346898],X_61=[7346898],X_66=[21]);" 3287,"(X_62=[21],X_63=[7346898]) := group.done(X_58=[7346898]);" 0,X_69 := bat.mirror(X_62=[21]); 25,X_69=[21] := bat.mirror(X_62=nil); 0,"X_71 := algebra.leftjoin(X_69=[21],X_58=[7346898]);" 27,"X_71=[21] := algebra.leftjoin(X_69=[21],X_58=[7346898]);" 0,"X_75 := mat.pack(X_68=[21],X_71=[21],X_74=[0]);" 28,"X_75=[42] := mat.pack(X_68=nil,X_71=nil,X_74=nil);" 0,"(ext23,grp21) := group.done(X_75=[42]);" 57,"(ext23=[21],grp21=[42]) := group.done(X_75=nil);" 0,X_15 := bat.mirror(ext23=[21]); 22,X_15=[21] := bat.mirror(ext23=[21]); 0,"X_77 := algebra.join(X_15=[21],X_59=[7346898]);" 31,"X_77=[21] := algebra.join(X_15=[21],X_59=nil);" 0,"X_79 := algebra.join(X_15=[21],X_9=:bat[:oid,:lng][0]);" 18,"X_79=[0] := algebra.join(X_15=[21],X_9=nil:bat[:oid,:lng]);" 0,"X_82 := algebra.project(X_58=[7346898],A0=1:bte);" 4479,"X_82=[7346898] := algebra.project(X_58=[7346898],A0=1:bte);" 0,"X_78 := algebra.join(X_15=[21],X_58=[7346898]);" 40,"X_78=[0] := algebra.join(X_15=[21],X_58=nil);" 0,"X_76 := mat.pack(X_77=[21],X_78=[0],X_79=[0]);" 67,"X_76=[21] := mat.pack(X_77=nil,X_78=nil,X_79=nil);" 0,"X_16 := algebra.join(X_15=[21],X_76=[21]);" 35,"X_16=[21] := algebra.join(X_15=nil,X_76=nil);" 0,X_85 := algebra.selectNotNil(X_82=[7346898]); 9,X_85=[7346898] := algebra.selectNotNil(X_82=nil); 0,"X_89 := aggr.sum(X_85=[7346898],X_63=[7346898],X_69=[21]);" 110078,"X_88=[21] := aggr.sum(X_84=nil,X_61=nil,X_66=nil);" 124961,"X_89=[21] := aggr.sum(X_85=nil,X_63=nil,X_69=nil);" 0,"X_87 := mat.pack(X_88=[21],X_89=[21],X_90=[0]);" 84,"X_87=[42] := mat.pack(X_88=nil,X_89=nil,X_90=nil);" 0,"X_17:bat[:oid,:lng] := aggr.sum(X_87=[42],grp21=[42],ext23=[21]);" 74,"X_17:bat[:oid,:lng] =[21] := aggr.sum(X_87=nil,grp21=nil,ext23=nil);" 131,barrier X_91 := language.dataflow(); 14,"X_19 := sql.resultSet(2,1,X_16=[21]);" 14,"sql.rsColumn(X_19=149,""sys.f_activity"",""product_sk"",""decimal"",10,2,X_16=nil);" 16,"sql.rsColumn(X_19=149,""."",""recordcount"",""bigint"",8,0,X_17=nil:bat[:oid,:lng]);" 4,X_31 := io.stdout(); 118,"sql.exportResult(X_31==""104d2"":streams,X_19=149);" 19,end s147_1; 30,function user.s147_1(A0=1:bte); 487983,X_5:void := user.s147_1(1:bte);

ticks,stmt 11,"X_19 := nil:bat[:oid,:str];" 9,"X_20:bat[:oid,:lng] := nil:bat[:oid,:lng];" 0,X_5 := sql.mvc(); 9,X_5 := sql.mvc(); 0,"X_50:bat[:oid,:str] := sql.bind(X_5=0,""sys"",""f_activity"",""fact_bk"",0,0,2);" 0,"X_11:bat[:oid,:str] := sql.bind(X_5=0,""sys"",""f_activity"",""fact_bk"",1);" 49,"X_11:bat[:oid,:str] =[0] := sql.bind(X_5=0,""sys"",""f_activity"",""fact_bk"",1);" 141,"X_50:bat[:oid,:str] =[2673449] := sql.bind(X_5=0,""sys"",""f_activity"",""fact_bk"",0,0,2);" 0,"X_56:bat[:oid,:str] := sql.bind(X_5=0,""sys"",""f_activity"",""fact_bk"",2,1,2);" 0,"X_54:bat[:oid,:str] := sql.bind(X_5=0,""sys"",""f_activity"",""fact_bk"",0,1,2);" 46,"X_56:bat[:oid,:str] =[0] := sql.bind(X_5=0,""sys"",""f_activity"",""fact_bk"",2,1,2);" 66,"X_54:bat[:oid,:str] =[2673449] := sql.bind(X_5=0,""sys"",""f_activity"",""fact_bk"",0,1,2);" 0,"X_13:bat[:oid,:oid] := sql.bind_dbat(X_5=0,""sys"",""f_activity"",1);" 0,"X_58 := algebra.kdifference(X_54=:bat[:oid,:str][2673449],X_56=:bat[:oid,:str][0]);" 74,"X_13:bat[:oid,:oid] =[0] := sql.bind_dbat(X_5=0,""sys"",""f_activity"",1);" 0,"X_14 := bat.reverse(X_13=:bat[:oid,:oid][0]);" 59,"X_14=[0] := bat.reverse(X_13=nil:bat[:oid,:oid]);" 0,"X_55:bat[:oid,:str] := sql.bind(X_5=0,""sys"",""f_activity"",""fact_bk"",2,0,2);" 26,"X_58=[2673449] := algebra.kdifference(X_54=nil:bat[:oid,:str],X_56=:bat[:oid,:str][0]);" 198,"X_55:bat[:oid,:str] =[0] := sql.bind(X_5=0,""sys"",""f_activity"",""fact_bk"",2,0,2);" 0,"X_60 := algebra.kunion(X_58=[2673449],X_56=:bat[:oid,:str][0]);" 0,"X_57 := algebra.kdifference(X_50=:bat[:oid,:str][2673449],X_55=:bat[:oid,:str][0]);" 259,"X_60=[2673449] := algebra.kunion(X_58=nil,X_56=nil:bat[:oid,:str]);" 285,"X_57=[2673449] := algebra.kdifference(X_50=nil:bat[:oid,:str],X_55=:bat[:oid,:str][0]);" 0,"X_59 := algebra.kunion(X_57=[2673449],X_55=:bat[:oid,:str][0]);" 0,"X_62 := algebra.kdifference(X_60=[2673449],X_14=[0]);" 172,"X_62=[2673449] := algebra.kdifference(X_60=nil,X_14=[0]);" 340,"X_59=[2673449] := algebra.kunion(X_57=nil,X_55=nil:bat[:oid,:str]);" 0,"X_65 := batstr.substring(X_62=[2673449],A0=1,A1=1);" 0,"X_61 := algebra.kdifference(X_59=[2673449],X_14=[0]);" 183,"X_61=[2673449] := algebra.kdifference(X_59=nil,X_14=[0]);" 0,"X_63 := algebra.kdifference(X_11=:bat[:oid,:str][0],X_14=[0]);" 188,"X_63=[0] := algebra.kdifference(X_11=nil:bat[:oid,:str],X_14=nil);" 0,"X_66 := batstr.substring(X_63=[0],A0=1,A1=1);" 279,"X_66=[0] := batstr.substring(X_63=[0],A0=1,A1=1);" 0,"X_90 := algebra.project(X_63=[0],A2=1:bte);" 198,"X_90=[0] := algebra.project(X_63=nil,A2=1:bte);" 0,X_93 := algebra.selectNotNil(X_90=[0]); 49,X_93=[0] := algebra.selectNotNil(X_90=nil); 0,"(X_73,X_74) := group.done(X_66=[0]);" 894,"(X_73=[0],X_74=[0]) := group.done(X_66=[0]);" 0,X_80 := bat.mirror(X_73=[0]); 201,X_80=[0] := bat.mirror(X_73=nil); 0,"X_81 := algebra.leftjoin(X_80=[0],X_66=[0]);" 364,"X_81=[0] := algebra.leftjoin(X_80=[0],X_66=[0]);" 0,"X_97 := aggr.sum(X_93=[0],X_74=[0],X_80=[0]);" 314,"X_97=[0] := aggr.sum(X_93=nil,X_74=nil,X_80=nil);" 0,"X_64 := batstr.substring(X_61=[2673449],A0=1,A1=1);" 33282589,"X_65=[2673449] := batstr.substring(X_62=[2673449],A0=1,A1=1);" 0,"X_89 := algebra.project(X_62=[2673449],A2=1:bte);" 1378,"X_89=[2673449] := algebra.project(X_62=nil,A2=1:bte);" 0,X_92 := algebra.selectNotNil(X_89=[2673449]); 11,X_92=[2673449] := algebra.selectNotNil(X_89=nil); 0,"(X_70,X_71) := group.done(X_65=[2673449]);" 50664,"(X_70=[1],X_71=[2673449]) := group.done(X_65=[2673449]);" 0,X_78 := bat.mirror(X_70=[1]); 28,X_78=[1] := bat.mirror(X_70=nil); 0,"X_79 := algebra.leftjoin(X_78=[1],X_65=[2673449]);" 79,"X_79=[1] := algebra.leftjoin(X_78=[1],X_65=[2673449]);" 0,"X_96 := aggr.sum(X_92=[2673449],X_71=[2673449],X_78=[1]);" 32191,"X_64=[2673449] := batstr.substring(X_61=[2673449],A0=1,A1=1);" 0,"X_88 := algebra.project(X_61=[2673449],A2=1:bte);" 2096,"X_88=[2673449] := algebra.project(X_61=nil,A2=1:bte);" 0,X_91 := algebra.selectNotNil(X_88=[2673449]); 10,X_91=[2673449] := algebra.selectNotNil(X_88=nil); 0,"(X_67,X_68) := group.done(X_64=[2673449]);" 52755,"(X_67=[1],X_68=[2673449]) := group.done(X_64=[2673449]);" 0,X_76 := bat.mirror(X_67=[1]); 25,X_76=[1] := bat.mirror(X_67=nil); 0,"X_77 := algebra.leftjoin(X_76=[1],X_64=[2673449]);" 42,"X_77=[1] := algebra.leftjoin(X_76=[1],X_64=[2673449]);" 0,"X_95 := aggr.sum(X_91=[2673449],X_68=[2673449],X_76=[1]);" 40039,"X_96=[1] := aggr.sum(X_92=nil,X_71=nil,X_78=nil);" 0,"X_82 := mat.pack(X_77=[1],X_79=[1],X_81=[0]);" 87718,"X_95=[1] := aggr.sum(X_91=nil,X_68=nil,X_76=nil);" 0,"X_94 := mat.pack(X_95=[1],X_96=[1],X_97=[0]);" 102183,"X_94=[2] := mat.pack(X_95=nil,X_96=nil,X_97=nil);" 217476,"X_82=[2] := mat.pack(X_77=nil,X_79=nil,X_81=nil);" 0,"(ext30,grp28) := group.done(X_82=[2]);" 62,"(ext30=[1],grp28=[2]) := group.done(X_82=nil);" 0,X_17 := bat.mirror(ext30=[1]); 23,X_17=[1] := bat.mirror(ext30=[1]); 0,"X_20:bat[:oid,:lng] := aggr.sum(X_94=[2],grp28=[2],ext30=[1]);" 0,"X_87 := algebra.join(X_17=[1],X_66=[0]);" 21,"X_20:bat[:oid,:lng] =[1] := aggr.sum(X_94=nil,grp28=nil,ext30=nil);" 0,"X_86 := algebra.join(X_17=[1],X_65=[2673449]);" 204422,"X_86=[0] := algebra.join(X_17=[1],X_65=nil);" 0,"X_85 := algebra.join(X_17=[1],X_64=[2673449]);" 101025,"X_87=[0] := algebra.join(X_17=[1],X_66=nil);" 207690,"X_85=[1] := algebra.join(X_17=[1],X_64=nil);" 0,"X_84 := mat.pack(X_85=[1],X_86=[0],X_87=[0]);" 547,"X_84=[1] := mat.pack(X_85=nil,X_86=nil,X_87=nil);" 0,"X_19 := algebra.join(X_17=[1],X_84=[1]);" 166,"X_19=[1] := algebra.join(X_17=nil,X_84=nil);" 310,barrier X_98 := language.dataflow(); 32,"X_22 := sql.resultSet(2,1,X_19=[1]);" 33,"sql.rsColumn(X_22=159,""sys."",""aa"",""varchar"",320,0,X_19=nil);" 46,"sql.rsColumn(X_22=159,""."",""recordcount"",""bigint"",8,0,X_20=nil:bat[:oid,:lng]);" 7,X_34 := io.stdout(); 279,"sql.exportResult(X_34==""104d2"":streams,X_22=159);"

------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/

_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |