RT 3.0.9 - Performance Enhancements and Oracle support

RT Developers
1

rt-announce mailing list
rt-announce@lists.bestpractical.com
http://lists.bestpractical.com/mailman/listinfo/rt-announce

PGP.sig (186 Bytes)

2

(as an aside, the PGP signature on that message was broken due to being
passed through mailman twice)

Request Tracker — Best Practical Solutions – Trouble Ticketing. Free.
rt-announce mailing list
rt-announce@lists.bestpractical.com
rt-announce Info Page

3

I’m pleased to announce the immediate availability of RT 3.0.9. This
version includes a new, tested port to Oracle 9iR2, as well as a number
of significant performance improvements.

Is the Oracle stuff 9i-specific, or is that just the only one you’ve
tested it on? We’re running 8.1.7 and I’d be glad to test it on there
if you’d like, especially if it means I could ditch my mysql setup.

xoa

Andy Lester => andy@petdance.com => www.petdance.com => AIM:petdance

4

I’m pleased to announce the immediate availability of RT 3.0.9. This
version includes a new, tested port to Oracle 9iR2, as well as a number
of significant performance improvements.

Is the Oracle stuff 9i-specific, or is that just the only one you’ve
tested it on? We’re running 8.1.7 and I’d be glad to test it on there
if you’d like, especially if it means I could ditch my mysql setup.

Well, aside from the fact that 8 doesn’t support LIKE searches on CLOBs
or ANSI left-join syntax, it might work. I’d love to hear a report, but
I strongly suspect the report will be “it’s broken.”

xoa

–
Andy Lester => andy@petdance.com => www.petdance.com => AIM:petdance

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

5

Well, aside from the fact that 8 doesn’t support LIKE searches on CLOBs
or ANSI left-join syntax, it might work. I’d love to hear a report, but
I strongly suspect the report will be “it’s broken.”

It does support contains(), though, if you have the InterMedia indices
turned on.

What does the ANSI left-join syntax look like? I’ve seen a bunch, but I
don’t know which is ANSI.

xao

Andy Lester => andy@petdance.com => www.petdance.com => AIM:petdance

6

Well, aside from the fact that 8 doesn’t support LIKE searches on CLOBs
or ANSI left-join syntax, it might work. I’d love to hear a report, but
I strongly suspect the report will be “it’s broken.”

It does support contains(), though, if you have the InterMedia indices
turned on.

What does the ANSI left-join syntax look like? I’ve seen a bunch, but I
don’t know which is ANSI.

Oracle simplifies SQL with ISO 99 Syntax see “LEFT OUTER JOIN”

xao

–
Andy Lester => andy@petdance.com => www.petdance.com => AIM:petdance

rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

7

Hi folks,

Just a word to say that RT 3.0.9 is REALLY faster than previous versions.
If you are using an older version I strongly suggest you upgrade.

Also, I strongly recommend (as does Jesse) using perl 5.8.3. Perl
5.8.0/1/2 have Unicode handling problems that will give you headaches if
you use anything other that plain English/ASCII, and even more so on
RedHat platforms.

Anyway, keep up the good work,

Patrick

8

Hi folks,

Just a word to say that RT 3.0.9 is REALLY faster than previous versions.
If you are using an older version I strongly suggest you upgrade.
seconded. I’ve NEVER seen RT3 be this fast!

Great work, Jesse!

Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749