Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 34875 invoked from network); 23 May 2008 01:32:34 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 23 May 2008 01:32:34 -0000 Received: (qmail 79758 invoked by uid 500); 23 May 2008 01:32:34 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 79726 invoked by uid 500); 23 May 2008 01:32:34 -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 79715 invoked by uid 99); 23 May 2008 01:32:34 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 May 2008 18:32:34 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [217.72.192.234] (HELO fmmailgate03.web.de) (217.72.192.234) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 May 2008 01:31:40 +0000 Received: from smtp06.web.de (fmsmtp06.dlan.cinetic.de [172.20.5.172]) by fmmailgate03.web.de (Postfix) with ESMTP id B455FDC1B2D2 for ; Fri, 23 May 2008 03:31:14 +0200 (CEST) Received: from [84.150.124.49] (helo=Sally) by smtp06.web.de with asmtp (WEB.DE 4.109 #226) id 1JzM7m-0002qS-00 for derby-user@db.apache.org; Fri, 23 May 2008 03:31:14 +0200 Message-ID: <00cd01c8bc74$b5d0d710$32b2a8c0@Sally> From: "Christian Gruber" To: Subject: How to store many large files in the database? Date: Fri, 23 May 2008 03:31:22 +0200 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 Sender: christian.gruber@web.de X-Sender: christian.gruber@web.de X-Provags-ID: V01U2FsdGVkX18U1XAFMUXLlbcCK0WEkSUTQoHa1oOJr6pA8i6+ r25KUyzFDREbzBF7+ziWZSXlG7ouDk30ITV8a7K3CzKNkKEjpk aYe+I2jT0CA5jF62X4Yg== X-Virus-Checked: Checked by ClamAV on apache.org Hi, the maximum size of a table is the maximum file size of the underlying operating system (e.g.: 2 GB). For data with a size of 10 MB I would reach the limit with about 200 entries. The data once in the table needs only be read (attachments of messages). Perhaps the new table function can be used to show the content of the filesystem as a table, when the attachments are stored outside of the database. Is there a way to distribute a table over more than one file or another solution? Any solution is appreciated! Thanks Christian