freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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')
-
slow , very slow,
Walgamotte, David, 09/20/2002
- <Possible follow-up(s)>
- Re: slow , very slow, Frediano Ziglio, 09/20/2002
- Re: slow , very slow, Walgamotte, David, 09/20/2002
- Re: slow , very slow, Bob Kline, 09/20/2002
- Re: slow , very slow, Walgamotte, David, 09/20/2002
- RE: slow , very slow, Lowden, James K, 09/20/2002
- RE: slow , very slow, Bob Kline, 09/20/2002
- RE: slow , very slow, cat, 09/20/2002
- RE: slow , very slow, Walgamotte, David, 09/20/2002
- RE: slow , very slow, James K. Lowden, 09/21/2002
- RE: slow , very slow, Leon Brooks, 09/21/2002
- RE: slow , very slow, Frediano Ziglio, 09/22/2002
- RE: slow , very slow, Kika Seixas, 09/24/2002
Archive powered by MHonArc 2.6.24.