most likely it ia one of optimizers. Use
debug select .....
and the look at the optimizers cost break down in the query plan, thus type
next
optimizers
see doc on line
On 5 aug. 2010, at 07:51, Jan Rittinger
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
------------------------------------------------------------------------------ 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