DBIx::SearchBuilder 1.10

I’m pleased to announce the availability of DBIx::SearchBuilder 1.10.
This new version has a few advantages over 1.01, the last production
release:

  • A number of code cleanups
  • An improved query builder for Postgres, Oracle and Sybase (more
    Sybase support is coming soon)
  • Faster record object instantiation
  • Better memory efficiency
  • A significantly improved record cache. (This includes a new
    dependency on Cache::Simple::TimedExpiry)
    In one of our local tests an import of 5000 users took 20 minutes on
    the wallclock with the new record cache vs 6 hours with the old cache.
    Additionally, the new cache is observably more adept at clearing out
    expired cache entries.
  • Fixed new query builder to interact better with RT2

This release of SearchBuilder was tested with RT 2.0, 3.0 and 3.2.

Expect to be able to download this new release from search.cpan.org or
your local CPAN mirror as the code propagates to your new mirror.

Jesse:

Sorry I don’t have your original posting on this issue since I deleted it.

w.r.t the RT Installation Manual on Wiki, it has the EXACT statement referring to
Innodb and MySQL. It is not worded as a requirment rather than a hint it is supported in
MySQL 4.x.

When I downloded RT 3.0.12, the manual (from bestpratical) was the only reference material
that I saw. Even though it contained many details, I found it difficult to follow and make
decissions on how to setup my RT.

I now have RT up for testing but later discovered some writeups by Sun on installing
RT on Solaris which added some light; some of which I have discovered on my own during the
fustrating process.

I know that attempting to always provide up-to-date documentation on a moving target is not
very easy but the draft manual does have a April 2003 date which is 16 months old! The
README file in the distribution that I downloaded had the same draft date.

Now a related subject … getting things straight …
If I want to convert my RT 3.0.12 DB to Innodb, is there anything else that is needed to be
done outside of:

 'alter table <tablename> type=innodb;'

for all of RT3 tables in MySQL? (after configuring/enabling Innodb first)

Can your revised and new DBIx::SearchBuilder 1.10 be used for RT 3.0.12 without harm? I
don’t want to upgrade to another moving target at this time.

-paul mcferrin

Jesse:

Sorry I don’t have your original posting on this issue since I deleted
it.

w.r.t the RT Installation Manual on Wiki, it has the EXACT statement
referring to
Innodb and MySQL. It is not worded as a requirment rather than a hint
it is supported in MySQL 4.x.

When I downloded RT 3.0.12, the manual (from bestpratical) was the
only reference material that I saw. Even though it contained many
details, I found it difficult to follow and make decissions on how to
setup my RT.

I’d be thrilled if you could update the wiki, then. That’s the point
of the wiki. The community can update it.

I don’t know about this “RT 3.0.12” that you’ve downloaded. Where did
you get it? The last 3.0.x release we’ve made is RT 3.0.11.

If I want to convert my RT 3.0.12 DB to Innodb, is there anything else
that is needed to be done outside of:

'alter table <tablename> type=innodb;'

for all of RT3 tables in MySQL? (after configuring/enabling Innodb
first)

Not to my knowledge. Want to put together a wiki article about the
process to help others?

Can your revised and new DBIx::SearchBuilder 1.10 be used for RT
3.0.12 without harm? I don’t want to upgrade to another moving target
at this time.

Yes. We’re running searchbuilder with RT 2.0, 3.0 and 3.2.

I would like to see a wiki article on innodb conversion please.From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Jesse Vincent
Sent: Thursday, September 09, 2004 10:43 PM
To: pmcferrin@att.net
Cc: Users of RT
Subject: [rt-users] Re: RT Installation Manual on Wiki

Jesse:

Sorry I don’t have your original posting on this issue since I deleted
it.

w.r.t the RT Installation Manual on Wiki, it has the EXACT statement
referring to
Innodb and MySQL. It is not worded as a requirment rather than a hint
it is supported in MySQL 4.x.

When I downloded RT 3.0.12, the manual (from bestpratical) was the
only reference material that I saw. Even though it contained many
details, I found it difficult to follow and make decissions on how to
setup my RT.

I’d be thrilled if you could update the wiki, then. That’s the point
of the wiki. The community can update it.

I don’t know about this “RT 3.0.12” that you’ve downloaded. Where did
you get it? The last 3.0.x release we’ve made is RT 3.0.11.

If I want to convert my RT 3.0.12 DB to Innodb, is there anything else
that is needed to be done outside of:

'alter table <tablename> type=innodb;'

for all of RT3 tables in MySQL? (after configuring/enabling Innodb
first)

Not to my knowledge. Want to put together a wiki article about the
process to help others?

Can your revised and new DBIx::SearchBuilder 1.10 be used for RT
3.0.12 without harm? I don’t want to upgrade to another moving target
at this time.

Yes. We’re running searchbuilder with RT 2.0, 3.0 and 3.2.

-paul mcferrin

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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

Yee, Matthew wrote:

I would like to see a wiki article on innodb conversion please.
Google will save you:
http://www.google.com/search?q=mysql+innodb+convert

Ooops!!! First link is:
http://dev.mysql.com/doc/mysql/en/Converting_tables_to_InnoDB.html

			Good luck. Ruslan.

Yee, Matthew wrote:

I would like to see a wiki article on innodb conversion please.

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Jesse Vincent
Sent: Thursday, September 09, 2004 10:43 PM
To: pmcferrin@att.net
Cc: Users of RT
Subject: [rt-users] Re: RT Installation Manual on Wiki

[… lines deleted]

If I want to convert my RT 3.0.12 DB to Innodb, is there anything else
that is needed to be done outside of:

‘alter table type=innodb;’

for all of RT3 tables in MySQL? (after configuring/enabling Innodb
first)

Not to my knowledge. Want to put together a wiki article about the
process to help others?

Don’t expect this article to come from me as I’m likely to be forced to retire a two weeks
after 35 years of service. The new charpter in my Life will NOT include sitting at a
computer terminal and playing around with RT. I got some traveling to do!

-paul