[wix-users] Many unnecessary queries on non existing table "Patch"

[Roland Kieslinger]

Hello!

I'm currently trying to optimize the performance of my msi installer and I found something, I don't understand. I don't have a table "Patch" in my msi, but the installer tries to query it extremely often (about 400 times). The whole duration of this process takes about 10 seconds. Here's the log:

Aktion gestartet um 17:45:29: InstallFiles.
MSI (s) (90:E8) [17:45:29:983]: Note: 1: 2205 2:  3: Patch
MSI (s) (90:E8) [17:45:29:984]: Note: 1: 2228 2:  3: Patch 4: SELECT `Patch`.`File_`, `Patch`.`Header`, `Patch`.`Attributes`, `Patch`.`Sequence`, `Patch`.`StreamRef_` FROM `Patch` WHERE `Patch`.`File_` = ? AND `Patch`.`#_MsiActive`=? ORDER BY `Patch`.`Sequence`
MSI (s) (90:E8) [17:45:29:984]: Note: 1: 2205 2:  3: MsiSFCBypass
MSI (s) (90:E8) [17:45:29:984]: Note: 1: 2228 2:  3: MsiSFCBypass 4: SELECT `File_` FROM `MsiSFCBypass` WHERE `File_` = ?
MSI (s) (90:E8) [17:45:29:984]: Note: 1: 2205 2:  3: MsiPatchHeaders
MSI (s) (90:E8) [17:45:29:984]: Note: 1: 2228 2:  3: MsiPatchHeaders 4: SELECT `Header` FROM `MsiPatchHeaders` WHERE `StreamRef` = ?
MSI (s) (90:E8) [17:45:29:989]: Note: 1: 2205 2:  3: PatchPackage
MSI (s) (90:E8) [17:45:30:002]: Note: 1: 2205 2:  3: MsiPatchHeaders
MSI (s) (90:E8) [17:45:30:002]: Note: 1: 2205 2:  3: PatchPackage
MSI (s) (90:E8) [17:45:30:039]: Note: 1: 2205 2:  3: Patch
MSI (s) (90:E8) [17:45:30:039]: Note: 1: 2228 2:  3: Patch 4: SELECT `Patch`.`Sequence`, `Patch`.`PatchSize`, `Patch`.`Attributes`, `Patch`.`Header`, `Patch`.`StreamRef_` FROM `File`,`Patch`,`Component` WHERE `File`=? AND `File`=`File_` AND `Component`=`Component_` ORDER BY `Patch`.`Sequence`
MSI (s) (90:E8) [17:45:30:190]: Note: 1: 2205 2:  3: Patch
MSI (s) (90:E8) [17:45:30:190]: Note: 1: 2228 2:  3: Patch 4: SELECT `Patch`.`Sequence`, `Patch`.`PatchSize`, `Patch`.`Attributes`, `Patch`.`Header`, `Patch`.`StreamRef_` FROM `File`,`Patch`,`Component` WHERE `File`=? AND `File`=`File_` AND `Component`=`Component_` ORDER BY `Patch`.`Sequence`
MSI (s) (90:E8) [17:45:30:202]: Note: 1: 2205 2:  3: Patch
MSI (s) (90:E8) [17:45:30:202]: Note: 1: 2228 2:  3: Patch 4: SELECT `Patch`.`Sequence`, `Patch`.`PatchSize`, `Patch`.`Attributes`, `Patch`.`Header`, `Patch`.`StreamRef_` FROM `File`,`Patch`,`Component` WHERE `File`=? AND `File`=`File_` AND `Component`=`Component_` ORDER BY `Patch`.`Sequence`
.
.
.
MSI (s) (90:E8) [17:45:38:930]: Note: 1: 2205 2:  3: Patch
MSI (s) (90:E8) [17:45:38:930]: Note: 1: 2228 2:  3: Patch 4: SELECT `Patch`.`Sequence`, `Patch`.`PatchSize`, `Patch`.`Attributes`, `Patch`.`Header`, `Patch`.`StreamRef_` FROM `File`,`Patch`,`Component` WHERE `File`=? AND `File`=`File_` AND `Component`=`Component_` ORDER BY `Patch`.`Sequence`
MSI (s) (90:E8) [17:45:38:940]: Note: 1: 2205 2:  3: Patch
MSI (s) (90:E8) [17:45:38:940]: Note: 1: 2228 2:  3: Patch 4: SELECT `Patch`.`Sequence`, `Patch`.`PatchSize`, `Patch`.`Attributes`, `Patch`.`Header`, `Patch`.`StreamRef_` FROM `File`,`Patch`,`Component` WHERE `File`=? AND `File`=`File_` AND `Component`=`Component_` ORDER BY `Patch`.`Sequence`
MSI (s) (90:E8) [17:45:38:969]: Note: 1: 2205 2:  3: Patch
MSI (s) (90:E8) [17:45:38:969]: Note: 1: 2228 2:  3: Patch 4: SELECT `Patch`.`Sequence`, `Patch`.`PatchSize`, `Patch`.`Attributes`, `Patch`.`Header`, `Patch`.`StreamRef_` FROM `File`,`Patch`,`Component` WHERE `File`=? AND `File`=`File_` AND `Component`=`Component_` ORDER BY `Patch`.`Sequence`
MSI (s) (90:E8) [17:45:38:995]: Doing action: CreateShortcuts
MSI (s) (90:E8) [17:45:38:995]: Note: 1: 2205 2:  3: ActionText
Aktion beendet um 17:45:38: InstallFiles. Rückgabewert 1.