title: MySQL Performance vs MSSQL Performance
body: <p>I am trying to compare the basic <em>insert</em> performance of <strong>MySql</strong> and <strong>MS SQL Server</strong>. The following MSSQL Query takes 1 second to execute using Business Management studio :</p>
  
  <pre><code>declare @i int
  set @i=1
  
  while (@i&lt;1000)
  begin
      insert into empmast 
          (name) values ( 'Client ' + cast(@i as varchar(10) ))
      set @i = @i + 1
  end
  go
  </code></pre>
  
  <p>A similar query in WorkBench takes 40 seconds to execute. Here is the Query :</p>
  
  <pre><code>DELIMITER $$
  DROP PROCEDURE IF EXISTS xproc_loop_test$$
  CREATE PROCEDURE xproc_loop_test()
  BEGIN
    DECLARE int_val INT DEFAULT 0;
    test_loop : LOOP
    IF (int_val &gt; 1000) THEN
    LEAVE test_loop;
  END IF;
  
  SET int_val = int_val +1;
  insert into empmast (name) values ( 'Client ' + int_val );
  END LOOP; 
  END;
  </code></pre>
  
  <p>Does this mean that MySQL is way slower in data insertion?</p>