[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