On Tue, 4 Nov 2003, [ks_c_5601-1987] 원태환 wrote: > I am considering to add mysql support as a backend of mboxlist DB. > I have used skiplist and Berkeley DB so far. > All of them have a serious contention problem. > But, I want to know if it is a valuable work .
I'm not sure what you mean by "a serious contention problem." Many sites use skiplist quite successfully. The access paterns against a cyrusdb don't map well to SQL -- in many cases we enumerate the entire database (or a large portion of it), and pull results at a higher level. I suspect you'll see more performance problems with a SQL backend (due to I/O) than you will with the memory mapped skiplist database (or a properly tuned Berkeley DB) -Rob -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Rob Siemborski * Andrew Systems Group * Cyert Hall 207 * 412-268-7456 Research Systems Programmer * /usr/contributed Gatekeeper
