PHP4/FreeTDS speed issue (long updates are slow)
Michael Kimsal
michael at tapinternet.com
Fri Jul 7 12:08:12 EDT 2000
$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/
More information about the FreeTDS
mailing list