# Toad for SQL server is the best (fastest) but how?

**URL:** <https://forums.toadworld.com/t/toad-for-sql-server-is-the-best-fastest-but-how/26965>\
**Category:** Toad for SQL Server\
**Created:** [October 3, 2013, 3:16am UTC](https://forums.toadworld.com/t/toad-for-sql-server-is-the-best-fastest-but-how/26965 "2013-10-03T03:16:33Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Francois](https://avatars.discourse-cdn.com/v4/letter/f/77aa72/32.png) [@Francois](https://forums.toadworld.com/u/Francois)\
**Post date:** [October 3, 2013, 3:16am UTC](https://forums.toadworld.com/t/toad-for-sql-server-is-the-best-fastest-but-how/26965/1 "2013-10-03T03:16:33Z")

</div>

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:

 ![enter image description here](http://i.stack.imgur.com/rDO3f.png)  
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?

Thanks!

François

Toad for SQL server 5.8.1