Tuesday, May 2, 2006 02:23 AM
The standard file store is optimized for FIFO processing. For this use case it is clearly faster than anything else. Direct access of a message somewhere at the end of a large queue is where a JDBC store is faster because of the DBMS' query optimizer etc.
However, the file store can be tuned to hold as much pages in its memory cache. A message requires at least one 2KB page in the store. Large messages require more pages. Say your average message size is 3 KB then it requires 2 pages. For 6000 messages this is 12000 pages. Add 10% for the index so you'd need 13200 pages for this queue. 13200 pages x 2 KB = 26400 KB = ~26 MB. That's not much. So you might try to configure your store cache with ~ twice of this size:
That way you won't have much disk access but your checkpoint duration would take a bit longer. Please give it a try.
Have a look here
how to tune the file store.