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 17:22:58 +0200


> -----Original Message-----
> 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
>
>
> > From: Gad Hayisraeli [mailto:gadh AT vmanage.com]
> > Sent: February 2, 2003 5:47 AM
> > To: freetds AT lists.ibiblio.org
> >
> > i found that the speed border is 14 columns, no matter their size.
> > to say: i tried "insert into " from linux client to sybase db
> > on windows, and these are the results:
> >
> > less than 15 columns = 185 LPS
> > 17 cols = 41 LPS
> > 26 cols = 3.5 LPS
>
> Gad,
>
> 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)

>
> 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
i did not need to use any performance tuning tips or odbc tunig in order to
get 100-300 lps , even over the network , os
why in the freetds i get only 3 lps !

by the way , i tried also openlink single tier + multitier drivers:
single tier - freetds based - 3 lps - like my freetds
multitier - uses openlink own agents in both client+srv sides = 30 lps

>
> This for sure: the TDS protocol is insensitive to column count. One column
> or a hundred, TDS doesn't care. If there's some negative interaction with
> the underlying packet layer, I'd be very surprised.
>
> --jkl

ok , so its probably the freetds implenetation , not the tds protocol itself
...
>
>
> > > -----Original Message-----
> > > From: freetds-admin AT lists.ibiblio.org
> > [mailto:freetds-admin AT lists.ibiblio.org]On Behalf Of Gad Hayisraeli
> > > Sent: Thursday, January 30, 2003 10:41 AM
> > > To: FreeTDS List
> > > Subject: [freetds] freetds is very,very slow when "insert
> > into" sybase 12.5
> > >
> > >
> > > my config:
> > > client : linux RH 6.2 x86, P-III 800 mhz, freetds 0.60,
> > iodbc driver manager , tds version 5.0
> > > data : 26 columns table (mainly strings)
> > > server : windows , sybase 12.5 ASE.
> > >
> > > (windows hardware is the same as linux)
> > >
> > > speed : 3.5 lines per second (lps) for "insert into" with
> > parameters.
> > >
> > > comparisons:
> > > =============
> > > windows,sybase - local (odbc of sybase) : 181 lps
> > >
> > >
> > > linux, mysql 3.23, remote( tcpip,odbc) - 145 lps
> > >
> > > so obviously its the tds that slows things down ( by more
> > than x20 ! )
> > >
> > > can someone explain why ?
> > >
> > > thanks
> > >
> > > Gad
> > >
> > >
> > >
> > >
> > > _______________________________________________
> > > FreeTDS mailing list
> > > FreeTDS AT lists.ibiblio.org
> > > http://lists.ibiblio.org/mailman/listinfo/freetds
> > >
> > >
> >
> >
> >
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
>
>
> 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