mySQL Script Performance in X6

[Zero-G.]

Hey

This is more an Information with the hope, that you will improve the Performance of InstallAware.
I use an Installation Script for mySQL (In SQL Database Section). The script is pretty huge with 11MB
When loading / saving the script, IA Needs up to about 7 Minutes, to respond again.

When I open the same script in a mySQL Software Editor, there is no time issue at all.

So, please Keep this in mind for further updates of your Software.
THX - Have a nice weekend

[FrancescoT]

Dear Zero-G,

as alternative approach, you can also replace the "MS SQL Server" command, with a call to SQLEXEC (MS SQL command line tool).

This can be useful when is necessary to run multiple scripts consecutively or when the mssql scripts are very big.

The SQLEXEC tool is installed by default by any MS SQL RTM installer and due of this, it's available with any target machine where MS SQL Server is already installed.

To call the SQLEXEC at runtime from your IA script, use the RUN PROGRAM command and specify the required parameters with the "CMD line" field (SQLEXEC command specifications are available with the Microsoft documentation).

The "RUN PROGRAM" call can be sequenced at any time in your script and the command allows the use of SCRIPT VARIABLES.

To embed your MS SQL SCRIPT FILES with your setup exe, add them to support files location. InstallAware uses support files at several places throughout the installation. Support files are not actually installed onto the target system, but they are part of the installation package. They are available temporarily while the installation is executing and are cleaned up when the installer finishes execution.

Once you added your "MS SQL SCRIPT FILES" to SUPPORTDIR, you can pass them as "SQLEXEC command line parameter" from your install script via RUN PROGRAM command (example; $SUPPORTDIR$\mySQLScript.sql).

For more details about SUPPORTDIR, search for "Modifying Support Files" in the IA documentation (press F1 from IA IDE).

Hope this helps you.


Regards