ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Zoran Avtarovski <zo...@sparecreative.com>
Subject Re: OT: COUNT query speed issue
Date Fri, 17 Jun 2005 03:57:12 GMT
OK. So indexing multiple columns is pretty easy and made a huge difference
to speed. As for single transaction, the answer is no. I thought that
waiting on 30 separate transactions would leave the connection open far too
long.

Z.


> Also, do you do this in the scope of a single transaction?
> 
> On 6/16/05, Ron Grabowski <rongrabowski@yahoo.com> wrote:
>> Do things get faster if you have the database index remote_id and
>> log_time?
>> 




Mime
View raw message