Re: Freetds slow on large inserts

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

_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds