Skip to Content.
Sympa Menu

freetds - Re: [freetds] Freetds slow on large inserts

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: <marco.baurdoux AT tourisoft.com>, "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Freetds slow on large inserts
  • Date: Tue, 9 Sep 2008 14:50:37 +0200

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

Attachment: smime.p7s
Description: S/MIME cryptographic signature




Archive powered by MHonArc 2.6.24.

Top of Page