[Rt-devel] rt2-to-rt3-1.23 out of memory
vivek at khera.org
Wed Oct 6 16:51:01 EDT 2004
On Oct 6, 2004, at 4:05 PM, Robert Westendorp wrote:
> Can you give an example of the query to removing orphan'd users? I
> think I
> might be having this issue .. we have 265,000+ users in the table and
> less tickets :)
Well, if you assume that users are only useful if they own tickets, do
a left-join on tickets with users on the owner field, then search for
users with ticket id IS NULL. I believe I posted the query to this
list (or the users list) a few months ago when I did the migration.
Vivek Khera, Ph.D.
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 2476 bytes
Desc: not available
Url : http://lists.bestpractical.com/pipermail/rt-devel/attachments/20041006/163de2c5/smime.bin
More information about the Rt-devel