[rt-users] My RT with #500000

Jim Meyer purp at acm.org
Mon Apr 18 14:08:16 EDT 2005


Hello!

On Thu, 2005-04-14 at 02:57, Matthew Watson wrote:
> Arh. I remember we when hit 500k tickets, oh so long ago. :)
> 
> 
> select count(*) from tickets
>   COUNT(*)
> ----------
>    1068891
> 1 row selected
>   
> select max(id) from tickets
>    MAX(ID)
> ----------
>    1331311
> 1 row selected

Out of curiosity ... what's this return?

select count(*) from transactions;

I'd also love to hear about what you've done to optimize RT for Oracle
(and vice versa). We're looking hard at RT and want to address some
concerns we see (or at least thought we saw) with scaling to 300000+
tickets.

Thanks!

--j
-- 
Jim Meyer, Geek at Large                                    purp at acm.org




More information about the rt-users mailing list