[freetds] Freetds slow on large inserts

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Tue Sep 9 08:50:37 EDT 2008

> Hello,
> Having used Freetds for quite some projects over the last 
> couple of years
> this is the first time I've come across a small problem.
> We are connecting to a SQL2000 DB via freetds 0.82 with 
> tds-ver=8 via PHP
> 4.4.9 (Yes I know we should upgrade :-)). That works fine. 
> Selects work
> fine. 
> However when we try to perform a "large" insert query we 
> mostly reach the
> apache Time-out. By large insert I mean creating around 3'000 
> records in one
> transaction.

do by large you mean a lot of records, some records with large columns (like images) or
both ??
In one transaction do you mean inside BEGIN TRAN/END TRAN? Or just you package a single
batch command?

> I've been trying to find some other posts about this issue 
> but haven't been
> able to find a satisfying solution. The only thing I've found 
> is that it is
> not related to Freetds. OK fine, however in this 
> configuration this is the
> only point where I believe someone can provide me with some 
> help and believe
> me I need some help.
> So anyone?
> Thanks in advance
> Marco Baurdoux

Which PHP module are you using?

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3129 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20080909/3d399241/attachment.bin 

More information about the FreeTDS mailing list