I'll try switching to int. Thanks. Yonik Seeley <[EMAIL PROTECTED]> wrote: On 9/2/07, michael ravits wrote: > this is the field definition: > > > holds message id's, values range from 0 to 127132531 > can I disable this cache?
No, sorting wouldn't work without it. The cache structure certainly isn't optimal for this (every doc probably has a different value). If you could live with a cap of 2B on message id, switching to type "int" would decrease the memory usage to 4 bytes per doc (presumably you don't need range queries?) -Yonik --------------------------------- Park yourself in front of a world of choices in alternative vehicles. Visit the Yahoo! Auto Green Center.