Re: Best database for implementing a cache

Why not just write then to the disk directly? Most File Systems can be
treated as a form a database, and it seems like thats kind of what you
want anyway.

Yes i am writing the image files directly to the filesystem as it is.
However i need to limit the size of the cache so that it may not grow
arbitarily large. that would require me to maintain access count
metric for evicting existing stored images. Since filesystem itself
would not let me assiciate this info with the image I tought of a
utilizing a database that would store the access count as well as all
the available images in the cache.


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 remote server is situated in another continent and will be
connected via a measly 100 Kbps isdn. The average image size is abt 1
Mb that would theoretically take 80 seconds to download. The clients
are connected to the server via 1000Mbps lan that can receive this
image in 0.008 seconds. So for the database connection that would
qualify as 'very fast' should let me acheive this theoretical limits
as close as possible ;-)

.

Relevant Pages

  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: Updating remote MySQL databases
    ... than over Internet directly to the database. ... > I want to maintain with the WinForms program. ... > remote server, that would probably be done with PHP or whatever. ... > the appropriate dialect down the TCP/IP connection from my local PC to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ESQL/C documentation nightmare
    ... documentation about explicit and implicit connections. ... CONNECTION connection statements for new applications of Version 6.0 ... the SQL database statements (such as ...
    (comp.databases.informix)