Skip to Content.
Sympa Menu

freetds - RE: [freetds] freetds is very,very slow when "insert into" sybase 12.5

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Gad Hayisraeli" <gadh AT vmanage.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] freetds is very,very slow when "insert into" sybase 12.5
  • Date: Mon, 3 Feb 2003 18:07:27 +0200


> -----Original Message-----
> From: freetds-admin AT lists.ibiblio.org
> [mailto:freetds-admin AT lists.ibiblio.org]On Behalf Of Lowden, James K
> Sent: þá 03 ôáøåàø 2003 17:48þ
> To: 'freetds AT lists.ibiblio.org'
> Subject: RE: [freetds] freetds is very,very slow when "insert into"
> sybase 12.5
>
>
> > From: Gad Hayisraeli [mailto:gadh AT vmanage.com]
> > Sent: February 3, 2003 10:23 AM
> > > From: freetds-admin AT lists.ibiblio.org
> > > [mailto:freetds-admin AT lists.ibiblio.org]On Behalf Of Lowden, James K
> > > Sent: Monday, February 03, 2003 4:18 PM
> > > To: 'freetds AT lists.ibiblio.org'
> > > Subject: RE: [freetds] freetds is very,very slow when "insert into"
> > > sybase 12.5
> > >
> > > How does the server perform by itself, without transporting
> > > the data over the network?
> >
> > simply by using its internal odbc driver to write into the
> > server (win client -> local win server)
>
> I meant: what data rate do you see in my suggested scenario?

about 180 lps
>
> > > Try inserting your data into a temporary table, and time a
> > > loop that reads
> > > the temp table and inserts the rows into the regular table.
> > > I think you'll find that the server itself slows down.
> >
> > but from the test results i showed here obviously its the
> > freetds that slows down
>
> No, Gad, you showed no such thing.
>
> You compared different database servers on different operating systems, and
> concluded it was "obviously" FreeTDS. When I pointed that out, you posted
> no response. When I suggested a plan better suited to yielding the
> information you seemed to want, you answered me with refutation.

ok , maybe i did not understand what you offer to prove that its not the
freetds that slows down. please explain again
how your test can prove this

>
> If you're genuinely interested in scientifically investigating database
> server and protocol performance, you need a better methodology than you've
> employed to date. I will help because if you do discover something, I'd
> like to know about it. If on the other hand you just want to publish
> embarrassing non sequitur conclusions, please go ahead and be my guest.
> Just don't expect any engagement here.
>
> The choice is yours.
>
> --jkl
>
>
> The information contained in this transmission may contain privileged and
> confidential information and is intended only for the use of the person(s)
> named above. If you are not the intended recipient, or an employee or agent
> responsible for delivering this message to the intended recipient, any
> review, dissemination, distribution or duplication of this communication is
> strictly prohibited. If you are not the intended recipient, please contact
> the sender immediately by reply e-mail and destroy all copies of the
> original message. Please note that we do not accept account orders and/or
> instructions by e-mail, and therefore will not be responsible for carrying
> out such orders and/or instructions.
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>







Archive powered by MHonArc 2.6.24.

Top of Page