Re: Memory Usage

2008-07-03 Thread Keith Watson
Thanks very much for this; I'll give it a shot. Keith. On 4 Jul 2008, at 00:02, Paul Smith wrote: (there are around 6,000,000 posts on the message board database) Date encoded as yyMMdd: appears to be using around 30M Date encoded as yyMMddHHmmss: appears to be using more than 400M! I g

Memory Usage

2008-07-03 Thread Keith Watson
Hello All, I have something that's not exactly causing me a major problem, but I would appreciate help in understanding the behaviour here: I have an internet message board, and I soon hope to revamp the code to be using Lucene for searching the threads and posts, as it's far better than