Subject | »Ø¸´£º [firebird-support] Re: About update clause's time. |
---|---|
Author | Svein Erling Tysvær |
Post date | 2005-08-22T08:58:04Z |
--- In firebird-support@yahoogroups.com, "Adam" wrote:
still puzzled by him needing two minutes for updating an integer in
27000 records. Hopefully, some of your comments will help discover the
cause.
Set
> Are you sure Set? Definitely an ascending index does not help for aYou're absolutely right, Adam, thanks for correcting me! Though I'm
> select max query so FB does not use it in that case, but I think it
> does use it for < and > operations (unfortunately I can not test it
> at this moment). Unless this is new in FB 1.5 and did not exist in
> 1.x?
still puzzled by him needing two minutes for updating an integer in
27000 records. Hopefully, some of your comments will help discover the
cause.
Set