Running Scripts Larger than 200 MB size in MySQL

This is a workaround for running a script from a very large file that you want to use to create/modify your database in MySQL.
After searching for possible workarounds, the easiest one that I found is to use a third-party tool called dbForge Studio for MySql. 

“dbForge Studio is a universal MySQL GUI tool that enables MySQL developers and administrators to create and execute queries, develop and debug MySQL routines, automate MySQL database object management in the convenient environment, and many others.”
More info on dForge Studio at: http://www.devart.com/dbforge/mysql/studio/

When you download this tool, make sure to download the Professional version which is a trial version instead of the Express (free version). Express version doesn’t support running files larger than 50 MB size.

Once you have dbForge Studio installed, connect to the database that you want to run the script for. Then, open your script file from File menu command. If the file bigger than 50 MB, then you will receive a message asking whether you want to execute the script directly instead of opening. Choose yes and the script will be executed at once.

SQL Improving Query Performance

1.     Use Indexes.
2.     Use All instead of UNION, OUTER UNION, EXCEPT and INTERSECT when you know there are no duplicate rows or when you know it does not matter whether duplicate rows are returned.
3.     Omit the ORDER BY clause unless necessary.
4.     Inline VIEWS or Temporary Tables?
      If the query is “long” and you are accessing the results from multiple queries, then use a Temporary Table to store the result from the query so that you can reuse it. Since a VIEW is just a select statement, the results need to be generated each time the view is called. Although subsequent runs of the view may be efficient because the results are stored in the cache, a temporary table actually stores the data.
5.     Use WHERE expressions with JOINS. JOINS without WHERE clause are often time consuming because of the ‘multiplier effect’ of the Cartesian Product.
6.     Replace multiple references to the DATE, TIME, DATETIME and ToDay functions in a single procedure. When the proc SQL ConstDateTime option or the SQLConstDateTime system option is set, proc SQL evaluates the date-time functions once through and uses the same result once throughout the whole query.