Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (hermes.apache.org: domain of larry.meadors@gmail.com
 designates 64.233.162.204 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=Jv95UeRRddcShmLRinYvapamKql6cA0B0PK33TCpjfR5h5bYogazHnWnFTTuOh8WaAk9BEzzRpo8fWTxP9wi14PJYLBiyNZsUGI6na6C/gi8SBMQwKZ5jkSMt+Uyyn1Ez1i32FDvOZ57qrkOuxIMcWcDyTq7sHfdaE3pm9b3QCE=
Message-ID: <a10a823c05061620572b79a199@mail.gmail.com>
Date: Thu, 16 Jun 2005 21:57:09 -0600
From: Larry Meadors <larry.meadors@gmail.com>
Reply-To: lmeadors@apache.org
To: user-java@ibatis.apache.org
Subject: Re: OT: COUNT query speed issue
In-Reply-To: <BED885AA.100BF%zoran@sparecreative.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <20050617031547.33586.qmail@web32203.mail.mud.yahoo.com>
	 <BED885AA.100BF%zoran@sparecreative.com>

Is this historical data? What I mean by that is, does it change frequently?=
=20

If not, maybe a better approach would be to periodically create a
table with the data in a summarized form.

>From the original email, it sounds like this approach may work for
data where the log_time is before today, but maybe not for today's
data. If that is the case, you could union the two queries (one over
the historical data, and one over the live data for today).

Larry

On 6/16/05, Zoran Avtarovski <zoran@sparecreative.com> wrote:
> > Do things get faster if you have the database index remote_id and
> > log_time?
> >
> The log_time column is indexed, but I couldn't work out how to index two
> columns in mysql.
>=20
> Z.
>=20
>=20
>