Re: Data pulling advice

On Thu, Jun 12, 2014 at 10:04:48AM +0100, Ashley Etherington wrote:
> Hi all looking for some advise on the best way to do the following.
> Now reporting has become an issue, Because of the slow method above if we try
> to do a report on more than 30 ticket the script takes about 5 Minutes, and any
> longer just fails.
> 
> We tried to fix this by editing the REST interface and exposing the Ticket
> Transactions field to the comment history REST but this just resulted in even
> slower response for every other script we work with that uses the REST. (We are
> not huge perl coders but it was a one line addition to expose the field and
> then dumping it in local)

Since you don't show your code, nobody can comment.

Looping over transactions for 30 tickets takes a few seconds locally
using RT's perl API.  Changing the REST API to dump transaction CFs
sounds like much more than a one line change.

-kevin

-- 
RT Training - Boston, September 9-10
http://bestpractical.com/training

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (Darwin)
Comment: GPGTools - http://gpgtools.org

iEYEARECAAYFAlOgmKgACgkQ0+gKWp5CJQrnswCfZ+BjGdRuijeZWbzDolYibFk5
ZxYAniQGcV8DuU+1hX9bxxWdeJyZoitn
=No2q
-----END PGP SIGNATURE-----