Ignore this please. Global variables are evil and I found a
few that
shouldn't exist.
Sorry for the emails.
On 27-Nov-06, at 9:49 AM, Rod Taylor wrote:
> I've been rearranging some of the elements in my
stories via soap.
> A single call (single XML submission) causes a huge
flood of events
> to be added.
>
> This story only has about 30 elements in total, yet
nearly 1000
> events are created for Element Additions.
>
>
> bric=# select event_type.name, count(*),
min(timestamp), max
> (timestamp) from event join event_type on
(event_type__id =
> event_type.id)where obj_id = 2694 and timestamp >
'2006-11-27'
> group by event_type.name;
> name | count | min
> | max
>
--------------------------------+-------+-------------------
--
> +---------------------
> Story Moved to Desk | 1 | 2006-11-27
14:29:44 |
> 2006-11-27 14:29:44
> Category Removed from Story | 1 | 2006-11-27
14:29:44 |
> 2006-11-27 14:29:44
> Element Added to Story | 1441 | 2006-11-27
14:29:44 |
> 2006-11-27 14:31:14
> Story Moved into Workflow | 1 | 2006-11-27
14:29:44 |
> 2006-11-27 14:29:44
> Contributor Added to Story | 1 | 2006-11-27
14:29:44 |
> 2006-11-27 14:29:44
> Contributor Removed from Story | 1 | 2006-11-27
14:29:44 |
> 2006-11-27 14:29:44
> Category Added to Story | 1 | 2006-11-27
14:29:44 |
> 2006-11-27 14:29:44
> Story Checked In | 1 | 2006-11-27
14:31:14 |
> 2006-11-27 14:31:14
> Story Checked Out | 1 | 2006-11-27
14:29:44 |
> 2006-11-27 14:29:44
> Story Changes Saved | 1 | 2006-11-27
14:31:14 |
> 2006-11-27 14:31:14
> (10 rows)
>
|