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... » read more

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... » read more