[Rt-devel] rt2-to-rt3-1.23 out of memory

[Vivek Khera]

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 
> way
> 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.
+1-301-869-4449 x806

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2476 bytes
Desc: not available
Url : http://lists.bestpractical.com/pipermail/rt-devel/attachments/20041006/163de2c5/smime.bin