You'll want to think about security with that second option. I don't think the MSI property is the issue. I think it's the SQLCA code itself that is slow parsing. IIRC, there is a (very old) bug about the perf problem. Maybe you'd like to tackle it?
-----Original Message----- From: Levi Wilson [mailto:l...@leviwilson.com] Sent: Thursday, January 23, 2014 10:41 AM To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] SqlScript with large schema setup Sorry I didn't mention this before, but the database is already going to exist. Our customers create this beforehand. The installer will just be running the SQL script for the initial schema to create all of our tables, triggers, sprocs, etc. When looking at the installer log, I see two lines that jump out at me: MSI (s) (C4!BC) [11:44:00:998]: Closing MSIHANDLE (45) of type 790540 for thread 12732 MSI (s) (C4!BC) [11:50:33:616]: PROPERTY CHANGE: Adding ExecuteSqlStrings property. Its value is '**********'. So it looks like it takes 6 minutes to take the 144k lines of my SQL script that is stored in a <binary /> to create the ExecuteSqlStrings property. Seems like I'm holding it wrong :-) Would a better option be to create a CA that reads the SQL out of a binary record and execute it myself? Rather than having the intermediate step of creating an MSI property? Levi > Why not right click on the DB, tasks and generate in MS? What version > of SQL? > On Thu, Jan 23, 2014 at 10:52 AM, Levi Wilson <levi@...> wrote: > > I am using a <SqlScript /> to create our database schema. I exported > > the schema using RedGate. The file is 10MB (I know, I know...). > > Everything works as expected, but during the installation the > > "Configuring SQL > Server" > > takes forever. > > > > I know, 10MB file with 144k lines of SQL to parse is a lot...is > > there a better alternative to getting this initial script created? > > > > Thanks in advance, > > > > Levi > > > > > ---------------------------------------------------------------------- > -------- > > CenturyLink Cloud: The Leader in Enterprise Cloud Services. > > Learn Why More Businesses Are Choosing CenturyLink Cloud For > > Critical Workloads, Development Environments & Everything In Between. > > Get a Quote or Start a Free Trial Today. > > > > > http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg. > clktrk > > _______________________________________________ > > WiX-users mailing list > > WiX-users@... > > https://lists.sourceforge.net/lists/listinfo/wix-users > > > -- > "They may forget what you said but they will never forget how you made > them feel." -- Anonymous ------------------------------------------------------------------------------ CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments & Everything In Between. Get a Quote or Start a Free Trial Today. http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments & Everything In Between. Get a Quote or Start a Free Trial Today. http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
