Skip to Content.
Sympa Menu

freetds - Re: PHP4/FreeTDS speed issue (long updates are slow)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Michael Kimsal" <michael AT tapinternet.com>
  • To: freetds
  • Subject: Re: PHP4/FreeTDS speed issue (long updates are slow)
  • Date: Fri, 7 Jul 2000 12:8:12


$db->query("update sessions set session='$val',gc='".time()."' where
sesskey='$sessid'");

If I comment that line out, everything is blistering. If I leave it
in, I'm back to 100-300 extra ms.

My *reads* aren't long at all - even pulling back a 1200+ row
record set, the system is quite quick. However, it seems writing
is slow. As the $val gets longer, the system is slower.

I've got this compiled as tdsver=7.0. 4.2 is not much faster, but it
gets rid of the 512 byte problem I was having.

On a separate note, I've tried tdsver=5.0, but that doesn't seem to work
at all - I'm using SP2 on SQL7, which I thought I'd read could handle
tds5.0, but I can't find where I read that (did I just make that up?)


On 07/07/00, "brlewis AT alum.mit.edu" wrote:
> Can you isolate just where the page is taking so much time? If it's in
> building the string, then it's a PHP4 problem. If it's in executing the
> statement, then it's a FreeTDS problem.
>
> Are you doing a long series of insert values, or just one long insert
> select?
>
> --
> Bruce R. Lewis http://brl.sourceforge.net/




Archive powered by MHonArc 2.6.24.

Top of Page