Sounds like it might be a performance problem in the SQL CustomActions. Can you look in a verbose log file and see what actions are taking the longest? Breakdown of details will help us target the things that are actually slow.
-----Original Message----- From: Eitan Behar [mailto:[EMAIL PROTECTED] Sent: Sunday, December 07, 2008 12:21 To: 'General discussion for Windows Installer XML toolset.' Subject: Re: [WiX-users] Very slow performance running SQL Scripts I haven't tried that, I will check tomorrow morning, but I think that they will run also fast. I tried the same scripts on Install Shield 12 and they take around 10 mins to run. -----Original Message----- From: Joe Osman [mailto:[EMAIL PROTECTED] Sent: Sunday, December 07, 2008 10:00 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Very slow performance running SQL Scripts Hi Eitan, How much does it take for your script to run if you use sqlcmd from the command window? Eitan Behar wrote: > Hi, > > I am having a serious performance problem with SQL Scripts, and would > appreciate some help troubleshooting it. > > This is the scenario: Use WIX to create the database, use script (within the > component creating the database) changing database properties, use > scripts on different component to create tables, and fill data, some scripts > are pretty big (70k+ rows). > > If I do the process from SQL Studio, it takes barely 5 minutes, from WIX it > takes more than 1 hour !!!! > > Here is the log: > > MSI (s) (6C!7C) [13:26:04:695]: Doing action: CreateDatabase > Action start *13:26*:04: CreateDatabase. > MSI (s) (6C!7C) [*13:56*:42:069]: PROPERTY CHANGE: Adding ExecuteSqlStrings > property. Its value is > 'MyData_SQL_DB€RDDP-VM29€€master€-2147483648€1€€€01_properties.sql€1€USE > [master]€Data_properties.sql€1€EXEC dbo.sp_dbcmptlevel @dbname=N'AuxData', > @new_cmptlevel=90€AuxData_properties.sql€1€IF (1 = > FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) > begin > EXEC [AuxData].[dbo].[sp_fulltext_database] @action = 'enable' > end (...) ALTER DATABASE [AuxData] SET AUTO_CLOSE OFF... > Action ended *13:26:04*: CreateDatabase. Return value 1. > MSI (s) (6C!7C) [*13:56:42*:132]: Doing action: ExecuteSqlStrings > Action start 13:56:42: ExecuteSqlStrings. > Action ended 13:56:42: ExecuteSqlStrings. Return value 1. > > Thanks, > > Eitan > > (BTW, I just installed the latest 3.0.x version, but happened also with > previous ones) > ------------------------------------------------------------------------------ > SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. > The future of the web can't happen without you. Join us at MIX09 to help > pave the way to the Next Web now. Learn more and register at > http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > ======================================================================= This email, including any attachments, is only for the intended addressee. It is subject to copyright, is confidential and may be the subject of legal or other privilege, none of which is waived or lost by reason of this transmission. If the receiver is not the intended addressee, please accept our apologies, notify us by return, delete all copies and perform no other act on the email. Unfortunately, we cannot warrant that the email has not been altered or corrupted during transmission. ======================================================================= ------------------------------------------------------------------------------ SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
