From: "Adam Flinton" 

Oh & btw...if you want to speed stuff up...this can be fun to use as
your jdbc driver...it's meant for servers but.....if can speed up
OpenOffice & make it really quite snappy wrt data access.


http://www.phworks-online.com/cache.html

" PhDataCache brings to server designers a simple yet powerful
database cache at a cost that everybody can afford. As a caching JDBC
driver PhDataCache sits between your application and your database JDBC
driver. It intercepts all of your JDBC calls and, based on rules which you
define, determines whether or not to cache query responses. You have
complete control over what gets cached and for how long, and because it
uses the well defined JDBC interface, you needn't change a line of code in
your application!
And as if that weren't enough, PhDataCahe is free for non-commercial use
and comes with full source code.

Features include:

  a.. Standard JDBC interface for easy integration with your existing
software.
  b.. Simple XML defined rules to allow complete control over what gets
cached and for how long.
  c.. Easy access to runtime statistics and configuration information.
  d.. Local query capabilities to maximise cache efficiency.
  e.. Background refreshing to enable cache updates during periods of low
application usage.
  f.. Powerful yet simple APIs to facilitate cache management and clean up.
  g.. Connection pooling to minimise database connection overheads.
  h.. Explicit cache access for even finer control over caching policies.
Visit our Downloads section today and try out PhDataCache for free."



Adam


"Joe Barr"  wrote in message
news:3e47fe02$1{at}w3.nls.net...
> On Mon, 10 Feb 2003 19:29:17 +0000, Adam Flinton wrote:
>
> > I've used the JDBC stuff easily & without messing about against Oracle,
> > DB2, MySQL, PostGreSQL & Sybase....
> >
> > Alternatively....I've never used the ODBC stuff because I do swap
between
> > Windows & Linux & using JDBC allows me to do so with next to 0
> > messing.....got db2java.zip or classes12.zip...good to go on either OS.
> >
>
>
> That's a good point in favor of JDBC.

--- BBBS/NT v4.01 Flag-4