23 Jul
2010
23 Jul
'10
12:40 a.m.
I'm back with this subject, it's really a haunting subject.
When at this stage, I can only wait that a graceful person restarts
the MySQL thus killing the "bad" query.
I would wish a DBCP or hibernate configuration for a maximum time
(which I'd put around 30 seconds because indeed, overload may cause
some queries to be very slow, but that would still release my MySQL
after those 30 seconds).
In many cases, paging doesn't help solve this issue since sorting is
often activated.
Hints would be really welcome.
thanks in advance
paul
Le 18-janv.-10 à 13:44, Anca Luca a écrit :
agreed for this particular case, but the discussion
was about hqls
which take
too much time. To the limit, somebody might _actually_ need all
these tables
joined, and we wouldn't call that "bad", wouldn't we?
If we put the problem like this, then we have a conversation about
how to
enforce people to join tables only by foreign keys (which we don't
even have set
in xwiki iirc), which is another discussion.