[rt-users] Starting ticket numbering at a given number

[Nils-Erik Svangård]

Ruslan U. Zakirov wrote:

> Nils-Erik Svangård wrote:
> [snip]
>
>>>> Ok, if I want to all searches to by default search the latest 2000 
>>>> tickets and not all 45000. Is that possible?
>>>
>>>
>>>
>>> strictly 2000 - no, but in RT-3.2 you can add condition
>>> id > XXXX, you should choose XXX according to your max id value.
>>> For example you current last ticket id is 233000 then you can add 
>>> 'id > 200000' to search only in last ~33000(note ~)
>>
>>
>>
>>
>> Ok I'll try that.
>> Is it possible to add somewhere so that condition is default, and 
>> users must activly delete it when they want to search older than 
>> 33000tickets?
>
> I think no, without some hacking. RT doesn't have any interface to 
> setup default search condition, but also this should be dinamic 
> condition(you ticket id is always growing).
>
> I think you try to speed up searches, don't you? Or you have another 
> reason?
>
>> /nisse
>>
Yes I'm trying to speed things up. When running specific searches mysql 
will eat 99% of the cpu, and stay alive for very long time, when I found 
the problem it had been running for 52hours!
/nisse

-- 
<+--//  							\\--+>
	       Datorcentralen Luelå tekniska universitet	  
	Name:	Nils-Erik Svangård	e-mail:	nisse at dc.ltu.se	  
	Ph:	+46-920-49244		URL:http://www.dc.ltu.se  
<+--\\								//--+>