mySQL Script Performance in X6

Got a problem you cannot solve? Try here.
Zero-G.
Posts: 41
Joined: Thu Nov 19, 2009 7:42 am

mySQL Script Performance in X6

Postby Zero-G. » Fri May 19, 2017 6:50 am

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
Site Admin
Posts: 5360
Joined: Sun Aug 22, 2010 4:28 am

Re: mySQL Script Performance in X6

Postby FrancescoT » Fri May 19, 2017 9:27 am

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
Francesco Toscano
InstallAware Software

White Papers (HowTos) - http://www.installaware.com/publication ... papers.htm
Publications - http://www.installaware.com/publications-review.htm
InstallAware Help -F1 anywhere in the InstallAware IDE


Return to “Technical Support”

Who is online

Users browsing this forum: No registered users and 32 guests