Icon View Incident Report

Serious Serious
Reported By: Arnd Baranowski
Reported On: 6/25/2013
For: Version 4.36 Build 1
# 3874 Prior Join Fix Can Cause Slowdowns with Join Conditions Containing Expressions

The following Query flies up to DBISAM 4.35 Build 2, but with DBISAM 4.36 Build 1 it is down to snail speed.




Insert Into "\Memory\Mapping86_1"
(Destinationid,Destination,Dialcode,
  Carrier_Dest,Carrier_Code,Timezone,Tzidentified,
  price1,price2,price3,orgwhrg,orgprice1,orgprice2,orgprice3,
  bill_int1,bill_int2,
  info1,info2,info3,identrun,Validon)
Select
   D.Destinationid,D.Destination,D.Dialcode,
   R.destination,R.Code,R.tzcarrier,R.tzidentified,
   R.preis,R.preis2,R.preis3,R.orgwhrg,R.orgpreis,R.orgpreis2,R.orgpreis3,
   R.Bill_Intervall1,R.Bill_Intervall2,
   R.Info1,R.Info2,R.Info3,2,Cast('2013-04-01' as Date)
  from
   "D:\Databases\D2010\mtcarrierdb_5001_11\MasterData_DB\RC_MasterData86" R inner oin "D:\Databases\D2010\mtcarrierdb_5001_11\Dest_Prot" D on
   D.Dialcode = left(R.Code,length(R.Code)-20)
  WHERE
   (Cast('2013-04-01' as Date) >= R.Gueltigab and (Cast('2013-04-01' as Date) < R.Gueltigbis or R.Gueltigbis is Null)) and
   R.tzcarrier = 3 and
   (Cast('2013-04-01' as Date) >= D.Validfrom and Cast('2013-04-01' as Date) < D.ValidUntil)
   and
   R.Code not in (Select Carrier_Code from "\Memory\Mapping86_1" WHERE Timezone = 3)
JoinOptimizeCosts;



Comments Comments
The fix that broke this was for incident #3839.


Resolution Resolution
Fixed Problem on 6/26/2013 in version 4.36 build 2


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM CLX Client-Server
DBISAM CLX Client-Server with Source
DBISAM CLX Standard
DBISAM CLX Standard with Source
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

Image