Reported By: Zsolt Reported On: 2/10/2014 For: Version 2.15 Build 3
# 4007Derived Tables Not Being Removed Properly When SQL Statements are Unprepared We find edb slowing case: if use sql like the the following. After 1000 running it is 100 times slower and use more resource.
select * from (
select * from test_table where id= '+inttostr(i)+'
) a order by name
ResolutionFixed Problem on 2/11/2014 in version 2.16 build 1
Products AffectedElevateDB Additional Software and Utilities ElevateDB DAC Client-Server ElevateDB DAC Client-Server with Source ElevateDB DAC Standard ElevateDB DAC Standard with Source ElevateDB DAC Trial ElevateDB LCL Standard with Source ElevateDB PHP Standard ElevateDB PHP Standard with Source ElevateDB PHP Trial ElevateDB VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial