freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] Defer prepare and prepexec

From: Frediano Ziglio <freddy77 AT gmail.com>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: [freetds] Defer prepare and prepexec
Date: Sat, 19 Jun 2010 14:15:06 +0200

I just committed some patches for prepare/execute performances. First prepare using tds7+ is always defered as ms drivers do. For this reason if you bind afterthe prepare server receive a single prepare, not two. Prepexec is used to collapse prepare and execute. So now a sequence like SQLPrepare/SQLBindParameter/SQLExecute can lead to' only 2 round trips instead of 6.

All tests passed, even perl ones.

Frediano Ziglio

[freetds] Defer prepare and prepexec, Frediano Ziglio, 06/19/2010