Re: [WiX-users] Very slow performance running SQL Scripts

2009-02-17 Thread Rob Mensching
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 v

Re: [WiX-users] Very slow performance running SQL Scripts

2009-02-16 Thread Alwayz
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 th

Re: [WiX-users] Very slow performance running SQL Scripts

2008-12-10 Thread Rob Mensching
ay, December 10, 2008 10:36 To: 'General discussion for Windows Installer XML toolset.' Subject: Re: [WiX-users] Very slow performance running SQL Scripts Actually if I don't run the 100k one, the package runs just fine. I cannot test the 100k alone since it needs the whole seque

Re: [WiX-users] Very slow performance running SQL Scripts

2008-12-10 Thread Eitan Behar
be glad to try it here, I have plenty of VMs with SQL running on them 8^) -Original Message- From: Rob Mensching [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 10, 2008 7:09 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Very slow performance

Re: [WiX-users] Very slow performance running SQL Scripts

2008-12-10 Thread Rob Mensching
- From: Rob Mensching [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 10, 2008 1:00 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Very slow performance running SQL Scripts How much text (without comments) are in these SQL Scripts again? -Original Me

Re: [WiX-users] Very slow performance running SQL Scripts

2008-12-09 Thread Eitan Behar
esday, December 10, 2008 1:00 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Very slow performance running SQL Scripts How much text (without comments) are in these SQL Scripts again? -Original Message- From: Eitan Behar [mailto:[EMAIL PROTECTED]

Re: [WiX-users] Very slow performance running SQL Scripts

2008-12-09 Thread Rob Mensching
ember 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 s

Re: [WiX-users] Very slow performance running SQL Scripts

2008-12-09 Thread Eitan Behar
ember 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 s

Re: [WiX-users] Very slow performance running SQL Scripts

2008-12-08 Thread Rob Mensching
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

Re: [WiX-users] Very slow performance running SQL Scripts

2008-12-07 Thread Eitan Behar
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 performanc

Re: [WiX-users] Very slow performance running SQL Scripts

2008-12-07 Thread Joe Osman
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,

[WiX-users] Very slow performance running SQL Scripts

2008-12-07 Thread 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 crea