StaticDB experience? Rollback to RuntimeDB simple?

[shostakovich]

Hi,

we currently have ~30k Tickets - and search performance, especially full text searching is pretty slow. Our users usually use the search box in the toolbar - and get a result after about 15 seconds. Well it's an Oracle db on a virtual machine - beside possible improvements on that side, I thought about introducing the OTRS search indexer and use StaticDB (Kernel::System::Ticket::IndexAccelerator::StaticDB).

This is recommended on 80k+ tickets and I cannot find too much about users experience with StaticDb. Well, I'd simply like to test if we get a performance boost if we use staticdb.

a) I'd like to have it create the index over night (there's a script in otrs/bin/ - but turn staticDB on via Sysconfig at another day. Is that possible?
b) Rollback: is it simple? I think I have to turn RuntimeDB on via sysconfig, then delete a database table which is holding the index?

Thanks for your advice.
Michael