Re: HSQLDB table modes

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Sat Aug 23 2008 - 11:22:09 EDT

  • Next message: Andrus Adamchik (JIRA): "[jira] Commented: (CAY-1039) Log level INFO for error at creating db table should be WARN"

    We ARE creating HSQLDB tables with CACHED option already. See
    "createTable" method:

    http://fisheye6.atlassian.com/browse/cayenne/trunk/framework/cayenne-jdk1.5-unpublished/src/main/java/org/apache/cayenne/dba/hsqldb/HSQLDBAdapter.java?r=617856

    Andrus

    On Aug 23, 2008, at 6:13 PM, Kevin Menard wrote:

    > Hi,
    > In his patch for CAY-1095 [1], Robert indicated that we should be
    > created
    > HSQLDB tables as cached. Not being overly familiar with it, I
    > looked into
    > the matter a bit, and I don't think it would pose any serious
    > backwards
    > compatibility issues for us. And it does indeed seem to bring a lot
    > of
    > benefits, save in the case where a database is small enough to fit
    > entirely
    > into memory. Before I go make the change, however, I wanted to know
    > why we
    > weren't doing it in the first place and if there's any reason that we
    > shouldn't.
    >
    >
    > [1] -- https://issues.apache.org/cayenne/browse/CAY-1095
    >
    > --
    > Thanks,
    > Kevin

    This archive was generated by hypermail 2.0.0 : Sat Aug 23 2008 - 11:22:44 EDT