Return-Path: Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: (qmail 27584 invoked from network); 5 Nov 2009 17:00:11 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 5 Nov 2009 17:00:11 -0000 Received: (qmail 38823 invoked by uid 500); 5 Nov 2009 17:00:10 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 38780 invoked by uid 500); 5 Nov 2009 17:00:10 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 38720 invoked by uid 99); 5 Nov 2009 17:00:10 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Nov 2009 17:00:10 +0000 X-ASF-Spam-Status: No, hits=-6.0 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE,RCVD_IN_DNSWL_MED X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [64.18.2.173] (HELO exprod7og110.obsmtp.com) (64.18.2.173) by apache.org (qpsmtpd/0.29) with SMTP; Thu, 05 Nov 2009 17:00:07 +0000 Received: from source ([209.85.222.180]) by exprod7ob110.postini.com ([64.18.6.12]) with SMTP ID DSNKSvMEg5OKnO9uCR7T8fcMwht4whCwkhaZ@postini.com; Thu, 05 Nov 2009 08:59:47 PST Received: by pzk10 with SMTP id 10so109419pzk.19 for ; Thu, 05 Nov 2009 08:59:46 -0800 (PST) MIME-Version: 1.0 Received: by 10.140.226.14 with SMTP id y14mr171014rvg.8.1257440386810; Thu, 05 Nov 2009 08:59:46 -0800 (PST) In-Reply-To: References: Date: Thu, 5 Nov 2009 11:59:46 -0500 Message-ID: Subject: Re: left join fetch with long text fields From: Daryl Stultz To: OpenJPA User List Content-Type: multipart/alternative; boundary=000e0cd151de9504bf0477a2a720 --000e0cd151de9504bf0477a2a720 Content-Type: text/plain; charset=ISO-8859-1 On Thu, Nov 5, 2009 at 11:52 AM, Daryl Stultz wrote: > slow. Is there some way to annotate this field so it is always retrieved in > the main query? Do I need to put a real limit on it? What would that be? > > Setting length = 1000000000 seems to do the trick (leaving database column as varchar(0)). A billion characters ought to be enough for my purposes (if JPA does any checking), but I still wonder if there's a better way. -- Daryl Stultz _____________________________________ 6 Degrees Software and Consulting, Inc. http://www.6degrees.com mailto:daryl@6degrees.com --000e0cd151de9504bf0477a2a720--