[Bug 12071] MSI SQL joins on tables with many rows are extremely slow ("Nero 7 essentials" installer)

http://bugs.winehq.org/show_bug.cgi?id=12071

Anastasius Focht  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[e-mail]
            Summary|MSI SQL joins on tables     |MSI SQL joins on tables
                   |with many rows are          |with many rows are
                   |extremely slow              |extremely slow ("Nero 7
                   |                            |essentials" installer)

--- Comment #5 from Anastasius Focht  2011-06-27 14:16:09 CDT ---
Hello,

updating bug status, still present.
"Nero 7 essentials" installer pegs the cpu ~45 mins on table joins _0o_

(winedbg bt while running)

--- snip ---
Backtracing for thread 0023 in process 001d (C:\windows\system32\msiexec.exe):
Backtrace:
=>0 0x7a7b7041 JOIN_fetch_int+0x63(view=0x1f4aa8, row=0x60083c45, col=0x9,
val=0x7fe48c) [/opt/projects/wine/wine-git/dlls/msi/join.c:73] in msi
(0x007fe474)
  1 0x7a7f3a11 STRING_evaluate+0x60(wv=0x1b5a00, row=0x60083c45, expr=0x1bea40,
record=(nil)) [/opt/projects/wine/wine-git/dlls/msi/where.c:276] in msi
(0x007fe4a4)
  2 0x7a7f3b10 STRCMP_Evaluate+0x4e(wv=0x1b5a00, row=0x60083c45, cond=0x1b5780,
val=0x7fe558, record=(nil)) [/opt/projects/wine/wine-git/dlls/msi/where.c:301]
in msi (0x007fe4d4)
  3 0x7a7f3df1 WHERE_evaluate+0x231(wv=0x1b5a00, row=0x60083c45, cond=0x1b5780,
val=0x7fe558, record=(nil)) [/opt/projects/wine/wine-git/dlls/msi/where.c:365]
in msi (0x007fe524)
  4 0x7a7f3ced WHERE_evaluate+0x12d(wv=0x1b5a00, row=0x60083c45, cond=0x1b58d8,
val=0x7fe5a8, record=(nil)) [/opt/projects/wine/wine-git/dlls/msi/where.c:348]
in msi (0x007fe574)
  5 0x7a7f3ced WHERE_evaluate+0x12d(wv=0x1b5a00, row=0x60083c45, cond=0x1b59e8,
val=0x7fe5fc, record=(nil)) [/opt/projects/wine/wine-git/dlls/msi/where.c:348]
in msi (0x007fe5c4)
  6 0x7a7f3fe5 WHERE_execute+0x16c(view=0x1b5a00, record=(nil))
[/opt/projects/wine/wine-git/dlls/msi/where.c:458] in msi (0x007fe624)
  7 0x7a7dd8d2 SELECT_execute+0x9d(view=0x1b5a40, record=(nil))
[/opt/projects/wine/wine-git/dlls/msi/select.c:181] in msi (0x007fe664)
  8 0x7a7c73b3 MSI_ViewExecute+0xb4(query=0x1f4640, rec=(nil))
[/opt/projects/wine/wine-git/dlls/msi/msiquery.c:462] in msi (0x007fe6a4)
  9 0x7a7c7494 MsiViewExecute+0xda(hView=0xb, hRec=0)
[/opt/projects/wine/wine-git/dlls/msi/msiquery.c:488] in msi (0x007fe6f4)
  10 0x1006b26f in msi4d5d.tmp (+0x6b26e) (0x007fe788)
  11 0x00000100 (0x100e9ce8)
  12 0x49534d43 (0x1006a900)
--- snip ---

$ wine --version
wine-1.3.23

Regards