Re: [PERFORM] startup caching suggestions

2007-06-25 Thread Bryan Murphy
No, but I was just informed of that trick earlier and intend to try it soon. Sometimes, the solution is so simple it's TOO obvious... :) Bryan On 6/25/07, Oleg Bartunov <[EMAIL PROTECTED]> wrote: On Mon, 25 Jun 2007, Bryan Murphy wrote: > We have a search facility in our database that uses f

Re: [PERFORM] startup caching suggestions

2007-06-25 Thread Oleg Bartunov
On Mon, 25 Jun 2007, Bryan Murphy wrote: We have a search facility in our database that uses full text indexing to search about 300,000 records spread across 2 tables. Nothing fancy there. The problem is, whenever we restart the database (system crash, lost connectivity to SAN, upgrade, config

[PERFORM] startup caching suggestions

2007-06-25 Thread Bryan Murphy
We have a search facility in our database that uses full text indexing to search about 300,000 records spread across 2 tables. Nothing fancy there. The problem is, whenever we restart the database (system crash, lost connectivity to SAN, upgrade, configuration change, etc.) our data is not cache