The SQL CustomAction code processes the scripts and removes all the comments and GO statements and other stuff that can't be fed directly to SQL. If you have a very large SQL Script that takes time.
I noted in another thread that this code needs some serious TLC. Something to revisit in WiX v4. Alwayz wrote: > 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 > ------------------------------------------------------------------------------ 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
