[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?

freddy77
-------------- 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