Slow queries are usually the result of the following items
that are not tuned: query SQL, database indexes, or operating system
resources. The performance problems that have distinct symptoms are
usually related to operating system resources.
Problem: Frequent out-of-memory errors
You are receiving frequent out-of-memory errors, and content-based
retrieval (CBR) query response times are possibly up to 250 seconds.