Hi Martin, Then I guess it's a bug. Please try running a query over 44k, you'll get MAPI = monetdb@localhost:50000 ACTION= read_line. QUERY = select count(*) from plk100 WHERE c15 IN ('00501','00544','01001','01002','01003'.......... ERROR = Connection terminated Any query under 44k runs fine, so I'm assuming the limit is 64k (query + other packet data) Thanks. Dariusz. Martin Kersten wrote:
dariuszs wrote:
Hi, Is there any limit on how big the sql query can be (in bytes)? Thanks. Dariusz.
As far as i am aware no.
------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users