Wow, you have a SQL Script that takes an hour to run? I've never seen anything
that complicated. Again, as I noted below, due to the way data is passed
around inside the Windows Installer, your script may be copied around several
times. Also, the WiX toolset is doing a bit of processing to break your script
down to pass it around inside the Windows Installer. It is entirely possible
that is causing the overhead you're seeing.
Just a general question, "What is in a 50 MB SQL Script that you need to
execute at install time?" A one hour wait during installation is not a great
user experience. I'm just trying to understand what the WiX toolset could do
to help.
From: Ian Couper [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 24, 2007 6:25 AM
To: Rob Mensching
Cc: wix-users@lists.sourceforge.net
Subject: RE: [WiX-users] SQL Script limit?
I just let the script run overnight and it finally did something. It ended up
failing on some line from the script, but aside from that the script took
almost 4 hours to run to that point, which wasn't even to completion. This
script normally takes about 20 min to 1 hour at the most to run, so there is
either something wrong with how I am handling it, or WiX can't handle the size
of script I am trying to run.
________________________________
From: Rob Mensching [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 23, 2007 11:55 AM
To: Ian Couper; wix-users@lists.sourceforge.net
Subject: RE: [WiX-users] SQL Script limit?
With the way that MSI works, you'll probably end up pushing the same 50 MB of
strings around 3 or 4 times. That could take time. Also, if you don't have
the latest WiX v2 code base, you could be hitting some old bugs in the SQL
processing.
After that, you could try debugging through the code and seeing what is taking
the longest. Maybe there is some perf we can improve, but I've never heard
anyone complain about this before.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ian Couper
Sent: Tuesday, January 23, 2007 8:25 AM
To: wix-users@lists.sourceforge.net
Subject: [WiX-users] SQL Script limit?
I have a large SQL script (30 to 50MBs) that I am trying to run from the MSI
using SQLScript. I have been able to run smaller scripts easily, but this large
one is not running at all and the MSI hangs. Is this a known issue with Wix
2.0? Is there a way to overcome this issue?
Thanks.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
