Hi Elke, Lars, @world; Zabach, Elke schrieb: >> some time ago I was suffering from Error -1104 "Too complicated SQL >> statement", which, after reading through the mailing list, I >> resolved by >> drastically increasing _PACKET_SIZE. So far, so good. >> >> Anyhow, now the problem is there again. _PACKET_SIZE is >> increased to its [...] >> >> However: Is there any help in that situation? > > Yes, as Lars wrote: think about the statement > or > increase _MBLOCK_STACK_SIZE
At first, thanks a lot for your hints. I will give it a try then to see whether I can get rid of my error that way. And yes, making the statement less complex would be the best way to go (after all, I see that modifying database parameters just will temporarily fix the problem - complexity of these statements is likely to increase as time passes and the amount of documents within the system gets bigger). However, right now we're unable of changing how that query actually looks like. Right this way it is created by the database core of the DMS we use, and we're not entitled to change the way this query is being built. We'll try working on it however. Thanks and bye, Kristian -- Kristian Rink -- Programmierung/Systembetreuung planConnect GmbH * Strehlener Str. 12 - 14 * 01069 Dresden Tel: 0351 4657770 * Fax: 0351 4657778 * [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
