Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 46962 invoked from network); 7 Jan 2010 16:37:48 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 7 Jan 2010 16:37:48 -0000 Received: (qmail 56515 invoked by uid 500); 7 Jan 2010 16:37:47 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 56468 invoked by uid 500); 7 Jan 2010 16:37:47 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 56460 invoked by uid 99); 7 Jan 2010 16:37:47 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Jan 2010 16:37:47 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [209.85.100.29] (HELO cpanel5.proisp.no) (209.85.100.29) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Jan 2010 16:37:38 +0000 Received: from mail-fx0-f220.google.com ([209.85.220.220]:44350) by cpanel5.proisp.no with esmtpsa (TLSv1:RC4-MD5:128) (Exim 4.69) (envelope-from ) id 1NSvMA-0005va-1r for derby-user@db.apache.org; Thu, 07 Jan 2010 17:37:06 +0100 Received: by fxm20 with SMTP id 20so19004474fxm.15 for ; Thu, 07 Jan 2010 08:37:15 -0800 (PST) MIME-Version: 1.0 Received: by 10.223.13.209 with SMTP id d17mr3241216faa.100.1262882235779; Thu, 07 Jan 2010 08:37:15 -0800 (PST) In-Reply-To: References: Date: Thu, 7 Jan 2010 17:37:15 +0100 Message-ID: Subject: Re: Derby memory consumption with many databases From: =?UTF-8?Q?=C3=98yvind_Harboe?= To: Derby Discussion Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - cpanel5.proisp.no X-AntiAbuse: Original Domain - db.apache.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - zylin.com X-Source: X-Source-Args: X-Source-Dir: > In case you go that route, I just thought I'd mention here that Derby > supports standard SQL schemas and SQL authorization (so users would be > protected from accessing each others schemas) in contrast to > e.g. MySQL, for which database and schema is more or less the same > thing. The problem I have with schemas is that it isn't really portable between databases... We would like to leave the database choice to the users. Our app is talking to Cayenne which provides the db abstraction. --=20 =C3=98yvind Harboe US toll free 1-866-980-3434 / International +47 51 63 25 00 http://www.zylin.com/zy1000.html ARM7 ARM9 ARM11 XScale Cortex JTAG debugger and flash programmer