Re: RT 4.2.7: SQL error on ticket traffic

Well that's a bummer, but it does explain why this instance has been so 
slow for 6+ years. Do you think it's viable to try and make the indexes 
for this database at this point, or is that a waste of time to 
investigate? The other option is that I just start fresh and use the old 
system (or a new read-only system) as a reference.

Thanks for your help.

--
Brian McNally

> ...there isn't even a primary key index on tickets there.  I have no
> idea how your database got into this state (I've never seen such
> before), but that would indeed be your problem.
-- 
RT Training - November 4-5 Los Angeles
http://bestpractical.com/training