PHP4/FreeTDS speed issue (long updates are slow)
michael at tapinternet.com
Fri Jul 7 10:36:28 EDT 2000
First off, I've not contributed before, but have lurked, and
am very grateful we've found FreeTDS - thanks to all involved!
Now, on to our problem here...
We're building a shopping application on Linux which is
using MSSQL7 on NT. The system was working fine
until we started storing the session data in the database
instead of the local filesystem. The longer the insert is
(more items in the shopping cart) the longer the page
seems to take. We're talking a page that took 80-100 ms
now taking 250-400 ms. Eventually, the page breaks,
as I get an "Invalid SQL query" error if the entire
query string is over 512 bytes (closest estimate I have
as to the breaking point).
Are there any switches/flags I can set to make this work
(and work faster)? This is currently compiled as -tdsver=7.0
I think - would going to 4.2 be better?
More information about the FreeTDS