Return-Path: 
 <derby-user-return-9954-apmail-db-derby-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-user-archive@www.apache.org
Received: (qmail 79708 invoked from network); 20 Oct 2008 05:22:19 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 20 Oct 2008 05:22:19 -0000
Received: (qmail 31476 invoked by uid 500); 20 Oct 2008 05:22:21 -0000
Delivered-To: apmail-db-derby-user-archive@db.apache.org
Received: (qmail 31019 invoked by uid 500); 20 Oct 2008 05:22:20 -0000
Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:derby-user-help@db.apache.org>
list-unsubscribe: <mailto:derby-user-unsubscribe@db.apache.org>
List-Post: <mailto:derby-user@db.apache.org>
List-Id: <derby-user.db.apache.org>
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Delivered-To: mailing list derby-user@db.apache.org
Received: (qmail 31008 invoked by uid 99); 20 Oct 2008 05:22:20 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 19 Oct 2008 22:22:20 -0700
X-ASF-Spam-Status: No, hits=-0.3 required=10.0
	tests=RCVD_IN_DNSWL_LOW,SPF_SOFTFAIL
X-Spam-Check-By: apache.org
Received-SPF: softfail (athena.apache.org: transitioning domain of
 kai@perfectreign.com does not designate 68.166.125.227 as permitted sender)
Received: from [68.166.125.227] (HELO smtp.cotse.net) (68.166.125.227)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Oct 2008 05:21:10 +0000
Received: from localhost (localhost[127.0.0.1])
        (authenticated bits=0)
        by smtp (5.7.4/5.7.4) with ESMTP id m9K5LHX2071882
        for <derby-user@db.apache.org>; Mon, 20 Oct 2008 01:21:18 -0400 (EDT)
        (envelope-from kai@perfectreign.com)
From: Kai Ponte <kai@perfectreign.com>
To: "Derby Discussion" <derby-user@db.apache.org>
Subject: Re: Most efficient way to get max row id?
Date: Sun, 19 Oct 2008 22:27:49 -0700
References: <eb9696930810191352k37ce5ac7ob62d1df8c637cfcf@mail.gmail.com>
 <MTAwMDA0OS54cjR0aQ.1224472758@quikprotect>
 <eb9696930810192115m4daada7fgaa1cea2c83f5d499@mail.gmail.com>
In-Reply-To: <eb9696930810192115m4daada7fgaa1cea2c83f5d499@mail.gmail.com>
X-Face: 
 "oj*h]W%'S.2+Ev"Fg#b0EA~7N:_:Fo6f}(28TE1I`YdavbqGM4\%ZZq|j0A>-xYbWj,=?utf-8?q?=5F9=0A=09TzO=5D=26umoB68=5BvUUAJ=25?=@Dljm\"85|%b,uI*u4@~%C<XuYW!FY_3XmWUHPx;,=?utf-8?q?2=273ng=24OlzsN=0A=09SH?=<~@|&G~2Mp~QB~/LrtGX:3JK;@
MIME-Version: 1.0
Content-Type: text/plain;
  charset="windows-1252"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <MTAwMDAzOS54cjR0aQ.1224480078@quikprotect>
X-Virus-Checked: Checked by ClamAV on apache.org

On Sunday 19 October 2008 09:15:55 pm Amir Michail wrote:
> > Do you have an index on the identity column? =A0What's your datatype?
>
> ~60,000 rows
>
> So if I put an index on the identity column, max will be fast?

It will certainly be faster than without.

=2D-=20
kai
www.filesite.org || www.perfectreign.com

=20
Clean out a corner of your mind and creativity will instantly fill it. - De=
e=20
Hock