FreeTDS Development Group

["Brandon M. Reynolds" <breynolds AT comtime.com>]

Not that I think this problem shouldn't be fixed (assuming that it is a
problem with FreeTDS), but why can't you use TDS7?  Can you at least
run the same query under TDS7 and see if you have similar problems?

Brandon M. Reynolds                    Ph: (330) 644-3059
Systems Engineer                       Fax: (330) 644-8110
Commercial Timesharing Inc.            Email: bmr AT comtime.com

> -----Original Message-----
> From: Michael Kimsal [mailto:michael AT note.themusicguide.com]
> Sent: None
> To: TDS Development Group
> Cc: camber AT ais.org
> Subject: [freetds] Re: large queries and TDS 7.0 revisited
> 
> 
> 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.