DBIx::SearchBuilder 1.10_04

RT Users
1

SearchBuilder 1.10_04 has just hit CPAN. This beta version should
resolve issues with the query builder that some folks have recently
seen on RT 2.0.x. (And has all the latest performance improvements as
well)

2

Hi Jesse,

I tried both DBIx::SearchBuilder 1.10_02 yesterday and
DBIx::SearchBuilder 1.10_04 today, and get an erroneous behaviour
regarding all ticket updates with both versions. The username for the
updator is blank:

Update with DBIx::SearchBuilder 1.10_04
Tue Aug 31 13:04:59 2004 - Due changed from Tue Aug 31 07:50:51
2004 to Tue Aug 31 13:14:59 2004

Update with DBIx::SearchBuilder 1.01
Tue Aug 31 13:06:16 2004 anders - Due changed from Tue Aug 31
13:14:59 2004 to Tue Aug 31 13:17:16 2004

Anybody else seen this?

Best Regards - Anders Ekstrand

3

To use the new version, it turns out you need to make sure all users
log out and log back in.
You can do this by deleting all entries from the sessions table.

I only discovered this about 8 hours ago.

JesseOn Aug 31, 2004, at 7:15 AM, Anders Ekstrand wrote:

Hi Jesse,

I tried both DBIx::SearchBuilder 1.10_02 yesterday and
DBIx::SearchBuilder 1.10_04 today, and get an erroneous behaviour
regarding all ticket updates with both versions. The username for the
updator is blank:

Update with DBIx::SearchBuilder 1.10_04

Tue Aug 31 13:04:59 2004 - Due changed from Tue Aug 31 07:50:51
2004 to Tue Aug 31 13:14:59 2004

Update with DBIx::SearchBuilder 1.01

Tue Aug 31 13:06:16 2004 anders - Due changed from Tue Aug 31
13:14:59 2004 to Tue Aug 31 13:17:16 2004

Anybody else seen this?

Best Regards - Anders Ekstrand

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf
Of Jesse Vincent
Sent: den 30 augusti 2004 23:48
To: Users of RT
Subject: [rt-users] DBIx::SearchBuilder 1.10_04

SearchBuilder 1.10_04 has just hit CPAN. This beta version
should resolve issues with the query builder that some folks
have recently seen on RT 2.0.x. (And has all the latest
performance improvements as
well)

The rt-users Archives

Be sure to check out the RT wiki at http://wiki.bestpractical.com

The rt-users Archives

Be sure to check out the RT wiki at http://wiki.bestpractical.com

4

I tried both DBIx::SearchBuilder 1.10_02 yesterday and
DBIx::SearchBuilder 1.10_04 today, and get an erroneous behaviour
regarding all ticket updates with both versions. The username for the
updator is blank:

Anybody else seen this?

Yes. I have fixed it locally using ->id memoization:

http://aut.dyndns.org/tmp/Cachable.pm

The error occurs because old objects in the session files did not have
the ->{_id} attribute. And in any case the pre-filling of ->{_id} is
unneccessary. Thus in the url above it becomes:

sub id {
my $self = shift;
return ( $self->{'_id'} ||= $self->SUPER::id );
}

Thanks,
/Autrijus/

5

Thanks,

That did the trick!

Lazy as I am, I have not set up any test-cases to compare the speed with
1.01 vs 1.10_04, but the feeling is that it is quite a bit faster now.

Best Regards - Anders

6

Anders Ekstrand wrote:

Thanks,

That did the trick!

Lazy as I am, I have not set up any test-cases to compare the speed with
1.01 vs 1.10_04, but the feeling is that it is quite a bit faster now.
Use http://path_to_rt_host/?Debug=1 with new and old version of
DBIx::SB(require apache stop/start after reinstall).
You can use this trick to “benchmark” important pages.

Best Regards - Anders

[snip]

7

Any other reports of problems? We are using RT v3.0.8 and would like to
upgrade SearchBuilder to the latest if it’s going to make a difference in
performance and it doesn’t break it.

Thanks!

8

I’ve had no problems since upgrading and the difference is incredible here.
Much more consistent and faster.

Adolfo Santiago wrote:

Any other reports of problems? We are using RT v3.0.8 and would like to
upgrade SearchBuilder to the latest if it’s going to make a difference in
performance and it doesn’t break it.

Thanks!

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com]On Behalf Of Ruslan U.
Zakirov
Sent: Wednesday, September 01, 2004 6:28 AM
To: Anders Ekstrand
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] DBIx::SearchBuilder 1.10_04

Anders Ekstrand wrote:

Thanks,

That did the trick!

Lazy as I am, I have not set up any test-cases to compare the speed with
1.01 vs 1.10_04, but the feeling is that it is quite a bit faster now.

Use http://path_to_rt_host/?Debug=1 with new and old version of
DBIx::SB(require apache stop/start after reinstall).
You can use this trick to “benchmark” important pages.

Best Regards - Anders

[snip]

The rt-users Archives

Be sure to check out the RT wiki at http://wiki.bestpractical.com

** CRM114 Whitelisted by: lists.bestpractical.com **

The rt-users Archives

Be sure to check out the RT wiki at http://wiki.bestpractical.com

With regards,

Say_Ten

This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed. In the event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or any information contained in it.

In the event of misdirection, illegible or incomplete transmission please telephone (023) 8024 3137
or return the E.mail to postmaster@multiplay.co.uk.

9

How about RT 3.0.5 ? if I upgrade to DBIx::SearchBuilder 1.11? No
problem either?

Matthew Cheale wrote: