On Tue, Oct 24, 2006 at 01:54:53PM -0400, Asif Iqbal wrote:
Here is another query that takes 6.95 secs
...
AND ( (main.Status = 'S')OR(main.Status = 'S') )
...
Is there a way to improve this?
guess
Introducing an 'OR' into any SQL generally slows it down. In this case
the OR appears to be
Here is another query that takes 6.95 secs
Count: 198 Time=6.95s (1377s) Lock=0.00s (0s) Rows=1.1 (224),
[EMAIL PROTECTED]
SELECT DISTINCT main.* FROM (((Tickets main JOIN Groups Groups_1
ON ( Groups_1.Instance = main.id)) LEFT JOIN CachedGroupMembers
CachedGroupMembers_2 ON (
This is mysql bug that wouldn't be fixed in 4.1 branch, but is fixed
in 5.x. I know how to fix this on RT side, but it's quite hard to
implement a solution and I don't think we'll have enough time for
this. Sorry. See also http://bugs.mysql.com/?id=20182
On 10/24/06, Asif Iqbal [EMAIL PROTECTED]
It is impossible to add an index without hurting the insert
queries; the question if it hurts it significantly enough for you to
notice. I would just try creating one and see what happens, you can
always delete it later if it makes the inserts/updates too slow.
On Sun, 22 Oct 2006, Asif
Resending my question in case anyone missed to catch it the first time around.
On 10/9/06, Asif Iqbal [EMAIL PROTECTED] wrote:
Hi
I am noticing from my slow log file (5 secs) that the following query
on mysql 4.0.24 is taking a 11 secs
# Query_time: 11 Lock_time: 0 Rows_sent: 299925
AFAIK RT doesn't execute such queries, I think you should look into
your customizations.
On 10/22/06, Asif Iqbal [EMAIL PROTECTED] wrote:
Resending my question in case anyone missed to catch it the first time around.
On 10/9/06, Asif Iqbal [EMAIL PROTECTED] wrote:
Hi
I am noticing from my