Hi! I'm running into performance related issues as well in WIX 2.0 when trying to create and populate a database.
Creating the database and tables work just fine. However the step where the MSI package is "Creating Databases" takes about 30 minutes when I attach my database content scripts to the MSI package. Please note that it is the pre-step to actually "Executing SQL Strings" that is taking time. During theese 30 minutes my MSIexec.exe process is running at 50% cpu and 100Mb of memory. The subsequent execution of the scripts is fast! We're talking about 5 minutes of execution time. What bugs me is waiting for 30 minutes while nothing happens. (I'm running SQL Profiler and no database calls are made during this time) What am I waiting for? The sql scripts are encoded in UTF-16m I've got about 300 content scripts ranging from 1k to 3,7 Mb. Would be really nice if it could be sped up! I've tried excluding all but one content script and then the MSI runs really fast. However with a large large number of files or with just plain large files the pre-execution is slow. Thanks, Jimmy Rob Mensching-2 wrote: > > I'm wondering if we've just crossed some unspoken threshold in the Windows > Installer. That or we have some N^2 (or worse) algorithm shredding the > SQL script and we don't feel it until 100K. Based on all of the bugs in > the SQL Script processing and a few of the feature requests, I think we > have a candidate for re-writing the CustomAction in WiX v4. I think IIS > CustomActions will need a similar re-write. Both of those CustomActions > were written before I had my newer tricks/understanding of CustomActions. > > Just so there are no surprises, I don't think we're going to make any > changes in WiX v3 here. SQL CAs seems pretty stable (now) and touching > them seems to only bring trouble. We'll avoid change until we get the > license to break things again (aka: WiX v4). > > -- View this message in context: http://n2.nabble.com/Very-slow-performance-running-SQL-Scripts-tp1625093p2334136.html Sent from the wix-users mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
