Re: Best database for implementing a cache
vj wrote On 03/30/07 14:42,:
Hi all,
I need to implement a cache of images that ae being fetched from a
remote server. So I am in need of a very fast file based database that
can fulfill my needs.
How fast is the connection to the remote server? How
much faster than that connection must your database be in
order to qualify as "very fast?" ;-)
The database should be embeddable with my
application and should store all its data in a file. I have explored
apache derby and hsqldb but they are probably overkill for my problem
since i do not need ACID transaction support moreover all data will be
stored in a single table rather than a single table.
A distinction of considerable subtlety ...
Any suggestion which database might server me well.
If I'm asking a question whose answer is obvious to
everyone else, I apologize, but: What do you want the
database to do for you? The only requirement you've
mentioned is that you want to deposit the images in it
"very fast," but you haven't said what you want to do
with them afterwards. Do you need to retrieve the images
in "as received" condition, or do you need to pluck out
bits and pieces of transformed image data? Do you need
to do OCR on the images and index them by all the words
that are recognized? Do you need to do face recognition,
fingerprint matching, ...?
If all you need is rapid writing, you're in luck:
Every Unix variant comes with an absolutely free, VERY
fast, write-only database called /dev/null ;-)
--
Eric.Sosman@sun.com