[rt-users] Other performance optimizations

[David C. Troy]

Steve -- one other thing.

In your delete_dead_tickets.pl script, you might try using:

$dbh->do($SQL);

for your DELETE statements rather than the $dbh->prepare/execute combo --
it's quicker and you can use it as long as you are not returning a
recordset.

Dave

=====================================================================
David C. Troy   [dave at toad.net]                   410-544-6193 Sales
ToadNet - Want to go fast?                        410-544-1329 FAX
570 Ritchie Highway, Severna Park, MD 21146-2925  www.toad.net

On Thu, 23 Aug 2001, David C. Troy wrote:

>
> A couple of other performance optimizations have come to mind that perhaps
> could be integrated:
>
>  -- Use syslog facilities for logging; writing a separate file for every
> single instance of RT seems really ludicrous
>
>  -- Better utilize Use vs. Require in Perl to provide for mod_perl startup
> optimizations -- someone else addressed this a week or so ago
>
>  -- Generally minimize RT process startup overhead by reducing what is
> loaded on a per-request basis
>
> While optimizing databases and creating additional indexes has helped
> performance immensely, I still think it could be zippier.  And of course
> isolating this darned segfault problem may be symptomatic of the need for
> some of these optimizations, or may lead to some other improvement.
>
> Dave
>
> =====================================================================
> David C. Troy   [dave at toad.net]                   410-544-6193 Sales
> ToadNet - Want to go fast?                        410-544-1329 FAX
> 570 Ritchie Highway, Severna Park, MD 21146-2925  www.toad.net
>
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
>