Skip to Content.
Sympa Menu

freetds - Re: slow , very slow

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Walgamotte, David" <david.walgamotte AT wild.net>
  • To: "'TDS Development Group'" <freetds AT franklin.metalab.unc.edu>
  • Subject: Re: slow , very slow
  • Date: Fri, 20 Sep 2002 15:26:03 -0500

Title: RE: [freetds] Re: slow , very slow

Thanks for responding ...

We use the following code, odbc is not used (I don't think) using freetds.

$dbMSSQL = mssql_connect("db","account","pass");
mssql_select_db("Northwind", $dbMSSQL);
$query = mssql_query("SELECT * FROM territories", $dbMSSQL);

-----Original Message-----
From: Frediano Ziglio [mailto:freddyz77 AT tin.it]
Sent: Friday, September 20, 2002 3:19 PM
To: TDS Development Group
Subject: [freetds] Re: slow , very slow


Il ven, 2002-09-20 alle 22:14, Walgamotte, David ha scritto:
>
> Why is free tds so slow ?
>
> Processing 584 rows: MYSQL takes 0.905979990959 seconds
>
> Processing 53 rows: MS SQL takes 1.26668703556 seconds
>
> If we do tens of thousand of records we can go out to
> lunch for burritos speedy.
>
> David
>
You don't tell who you insert these rows...
ctlib/dblib/odbc? bulk copy or not?
How do you process these rows ?

mysql is faster then mssql... simply because mysql is simpler !

freddy77



---
You are currently subscribed to freetds as: [david.walgamotte AT wild.net] To unsubscribe, forward this message to $subst('Email.Unsub')




Archive powered by MHonArc 2.6.24.

Top of Page