[rt-users] Bad query?

[Mark E. Dawson, Jr.]

>    There where a few other procs, all small select
> statements and update 
> statements, and all in a "locked" state.  I don't
> want to have to upgrade to 
> Oracle for a problem that only happens every few
> weeks.  

You don't have to upgrade to Oracle.  As I stated
before, you can do a dump of the DDL, append the
table type of INNODB to the create statements, and
thus be able to use tables with row-level locking.
This way, you can stay on MySQL.

Or, you could go a half-step up and use BDB tables
within MySQL, which would give you page-level lock-
ing, or something to that effect.

Either way, you have options that will keep you on
MySQL.  Personally, I've just finished demo-ing and
testing RT with upper management, and everyone just
loves the tool.  My plan is to migrate this to pro-
duction, but to convert the tables to InnoDB, since
we'll have 250+ employees creating, updating, and
searching tickets all at once.

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com