Hi, I have the same request that I run on the same server, the same database in two different mclient . The results are not the same. There is no activity on the server , no other query running. pcoustillas@groupelemonde:~$ mclient lemonde Welcome to mclient, the MonetDB/SQL interactive terminal (Oct2014-SP1) Database: MonetDB v11.19.7 (Oct2014-SP1), 'mapi:monetdb://groupelemonde:50000/lemonde' Type \q to quit, \? for a list of available commands auto commit mode: on sql>TRACE SELECT count(*) FROM ref__cookies__lemonde__os; +------+ | L1 | +======+ | 97 | +------+ 1 tuple (14.885ms) +-------+---------------------------------------------------------------------------------------------------------------------+ | ticks | stmt | +=======+=====================================================================================================================+ | 2 | X_2 := sql.mvc(); | | 13 | X_3:bat[:oid,:oid] =<tmp_32275>[97] := sql.tid(X_2=0,"sys","ref__cookies__lemonde__os"); | | 32 | X_6:bat[:oid,:int] =<tmp_5355>[97] := sql.bind(X_2=0,"sys","ref__cookies__lemonde__os","id",0); | | 9 | X_9=<tmp_26020>[97] := algebra.leftfetchjoin(X_3=<tmp_32275>:bat[:oid,:oid][97],X_6=<tmp_5355>:bat[:oid,:int][97]); | | 1 | X_10 := aggr.count(X_9=<tmp_26020>[97]); | | 503 | barrier X_31 := language.dataflow(); | | 4 | sql.exportValue(1,"sys.L1","L1","wrd",64,0,6,X_10=97:wrd,""); | | 0 | end s2_4; | | 555 | function user.s2_4(); | | 627 | X_5:void := user.s2_4(); | +-------+---------------------------------------------------------------------------------------------------------------------+ 10 tuples (14.976ms) pcoustillas@groupelemonde:~$ mclient lemonde Welcome to mclient, the MonetDB/SQL interactive terminal (Oct2014-SP1) Database: MonetDB v11.19.7 (Oct2014-SP1), 'mapi:monetdb://groupelemonde:50000/lemonde' Type \q to quit, \? for a list of available commands auto commit mode: on sql>TRACE SELECT count(*) FROM ref__cookies__lemonde__os; +------+ | L1 | +======+ | 0 | +------+ 1 tuple (6.841ms) +-------+------------------------------------------------------------------------------------------------------------------+ | ticks | stmt | +=======+==================================================================================================================+ | 2 | X_2 := sql.mvc(); | | 13 | X_3:bat[:oid,:oid] =<tmp_47161>[0] := sql.tid(X_2=0,"sys","ref__cookies__lemonde__os"); | | 9 | X_6:bat[:oid,:int] =<tmp_4226>[0] := sql.bind(X_2=0,"sys","ref__cookies__lemonde__os","id",0); | | 9 | X_9=<tmp_17466>[0] := algebra.leftfetchjoin(X_3=<tmp_47161>:bat[:oid,:oid][0],X_6=<tmp_4226>:bat[:oid,:int][0]); | | 1 | X_10 := aggr.count(X_9=<tmp_17466>[0]); | | 531 | barrier X_29 := language.dataflow(); | | 21 | sql.exportValue(1,"sys.L1","L1","wrd",64,0,6,X_10=0:wrd,""); | | 0 | end s2_1; | | 727 | function user.s2_1(); | | 868 | X_5:void := user.s2_1(); | +-------+------------------------------------------------------------------------------------------------------------------+ 10 tuples (6.951ms) any ideas ? thanks Pierre -- 1G6 52 route de bischwiller 67300 Schiltigheim Société de Services et de Formations en Logiciels Libres http://1g6.biz Tél : 06 64 63 70 35