FreeTDS Development Group

[Michael Kimsal <michael AT note.themusicguide.com>]

Large queries - I understand the speed issues involved, but I know this is
a size thing somehow.  I will try to do some timing issues and send them
to you, or can show you this week if you come thursday.

The final query we do is to store a serialized copy of the session
variables.  As the user is on, more things are in the session (yes, we
should probably clean it out!)  The serialized data becomes sometimes
200-300 bytes.  These queries still get done in usually < 10 ms.  I did a
test one time where I had a query of ~500 bytes - 10ms. Adding about 50
bytes or so *significantly* increased the delay in processing, even tho
the query was doing the same thing - just inserting an extrea 50 bytes or
so into a text field.  

I'll see what I can do to demonstrate this this week.

Thanks.  :0