[WiX-users] Very slow performance running SQL Scripts

[Eitan Behar]

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