search into ODP data - other solutions than live?

[Guest Awb]

Anybody had any significant success using ODP data into another db than MySQL? I know that most people here done it via live search but I was wondering if this has any performance using another database without huge costs. Or maybe some noticeable speed improvements on MySQL?

[hmf]

Re: search into ODP data - other solutions than li

 

I have used both Berkeley DB and object databases for storing odp data (the rdf dump). From what I read in the forums here this is *much* faster than mysql. Mysql and all other relational databases are unsuited to store hierarchically organized data like odp categories. Mail me if you are interested in my code.

To try you can use the new Berkeley DB which is almost an object database when used from Java or you can use the free presonal version from intersystems Caché.

regards Hans