We experiment low performance with SQL-server 2008 when performing massive INSERT queries. These queries are enclosed into transactions by batches of 25, 50, 100, or 200 rows.
On every application? no! Toad is much faster!
The following graph shows how Toad is much faster and steady than the 2 other applications, running exactly the same SQL script:
How can Toad be more performance than the two other lighter application? How can we reproduce this performance with jTDS or SQSH? Any idea?
Does Toad prepare the SQL query before executing it? Does open and close connection on each commit?
Toad for SQL server 5.8.1