Icon View Incident Report

Serious Serious
Reported By: Ole Willy Tuv
Reported On: 8/18/2000
For: Version 2.03 Build 1
# 615 Using an ORDER BY Clause on a Live SQL SELECT Statement Causes Inserts to Slow Down

Adding an ORDER BY clause to a live SQL SELECT query (but not affecting the liveness of the query) causes any inserted records into the live query to insert very slowly.

select * from a_table order by a_string1

Resolution Resolution
Fixed Problem on 8/22/2000 in version 2.04 build 1