MySQL Performance vs MSSQL Performance
<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>