Matthew Toseland wrote: > 4) Use a completely different database for the index. > 5) Use a completely different database for the whole store, and trust it not > to lose the data. (from our experience with BDB, it is likely that it will!) > 6) Roll our own database code.
7) Get rid of the secondary indices: store the data in the database instead of in files, removing the need to store block numbers, and use random deletion instead of LRU, removing the need to store the access time. Disclaimers: 1. I understand that it's not currently a good idea to store the data in the database because we lose everything if the database gets corrupted, but if getting rid of the secondary indices fixes the corruption problems then that will no longer be an issue. 2. I'm not pushing for LRU to be replaced, the issue just happens to have cropped up twice in a short period for different reasons. :-) Cheers, Michael
