On Nov 27, 2007 9:25 PM, Kenneth Marshall [EMAIL PROTECTED] wrote:
On Tue, Nov 27, 2007 at 09:49:45AM -0800, Gordon Messmer wrote:
Kenneth Marshall wrote:
The time to open and display a ticket varies based on the number
of transactions involved, but typically takes on the order of 1-3s.
Hi,
Make sure to delete the users in a safe way with rtx-shredder and not directly
from the db. Btw, about how many users we talk? We have NO performance problems
with 30.000 active and a half a million inactive users
Torsten
-Original Message-
From: [EMAIL PROTECTED] [EMAIL
Hello!
I also want to see only real users in my DB, it is not about
performance, but it would be nice number to show the management.
On Di, 2007-11-27 at 09:42 +0100, Ham MI-ID, Torsten Brumm wrote:
Make sure to delete the users in a safe way with rtx-shredder and not
directly from the db.
Ham MI-ID, Torsten Brumm wrote:
Hi,
Make sure to delete the users in a safe way with rtx-shredder and not
directly from the db.
I'd prefer to, but as I said before, it doesn't work. The newest
version of rtx-shredder has a User plugin that has a no_tickets option,
but when I use that, it
Sven Sternberger wrote:
oops!
On Di, 2007-11-27 at 10:07 +0100, Sven Sternberger wrote:
But rtx-shredder don't give you a simple way to delete all
users without a ticket, so you have to combine the select
statement from Gordon, and then call rtx-shredder
so Geordons sql statemaent is of
Here is our instance data, not slow at all:
rt36=# select count(*) from CachedGroupMembers;
count
-
1163547
(1 row)
rt36=# select count(*) from GroupMembers;
count
353086
(1 row)
rt36=# select count(*) from Groups;
count
473803
(1 row)
rt36=# select
Kenneth Marshall wrote:
Here is our instance data, not slow at all:
I'm willing to consider that I'm looking in the wrong place... When you
open a ticket, what's the time to display on your instance? Which DB
are you using, and what tuning did you do to it?
On Tue, Nov 27, 2007 at 08:36:42AM -0800, Gordon Messmer wrote:
Kenneth Marshall wrote:
Here is our instance data, not slow at all:
I'm willing to consider that I'm looking in the wrong place... When you
open a ticket, what's the time to display on your instance? Which DB are
you using,
Kenneth Marshall wrote:
The time to open and display a ticket varies based on the number
of transactions involved, but typically takes on the order of 1-3s.
With RT3 3.6.5 and PG 8.1.9, I'm seeing newish tickets open in a little
more than two seconds. I don't have numbers for MySQL 5, but I
On Tue, Nov 27, 2007 at 09:49:45AM -0800, Gordon Messmer wrote:
Kenneth Marshall wrote:
The time to open and display a ticket varies based on the number
of transactions involved, but typically takes on the order of 1-3s.
With RT3 3.6.5 and PG 8.1.9, I'm seeing newish tickets open in a little
10 matches
Mail list logo