On Aug 5, 2010, at 16:41, Jan Rittinger wrote:
On Aug 5, 2010, at 16:06, Stefan de Konink wrote:
On Thu, 5 Aug 2010, Manuel Mayr wrote:
Is there a parameter that allows me to increase the SQL query buffer?
I did see these issues before with large IN stuff, but lately I don't have them anymore. So you might report the bug as well. Does the issue also happen if you create a new table, with all items and do a IN (select ids FROM newtable); ?
Hmmm, I should be more informative about what I want to say...
cat test500.sql plan SELECT * FROM tables WHERE (tables.id IN (1,2,...,500));
cat test1000.sql plan SELECT * FROM tables WHERE (tables.id IN (1,2,...,1000));
time mclient test500.sql > /dev/null real 0m4.062s user 0m0.031s sys 0m0.006s
time mclient test1000.sql > /dev/null real 0m34.939s user 0m0.117s sys 0m0.008s
This example shows that the compilation of long IN lists screws up after some hundred of items. Manuel tried to run a query with some thousand items... To cope with queries that feature such long lists (e.g., stemming from generated ActiveRecord queries) other database turn the values in an IN clause into a temporary table. Might that be an option to speed up the code generation? Jan
Stefan
------------------------------------------------------------------------------ The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Jan Rittinger Lehrstuhl Datenbanken und Informationssysteme Wilhelm-Schickard-Institut für Informatik Eberhard-Karls-Universität Tübingen
http://www-db.informatik.uni-tuebingen.de/team/rittinger
------------------------------------------------------------------------------ The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Jan Rittinger Lehrstuhl Datenbanken und Informationssysteme Wilhelm-Schickard-Institut für Informatik Eberhard-Karls-Universität Tübingen http://www-db.informatik.uni-tuebingen.de/team/rittinger