Skip to Content.
Sympa Menu

freetds - Re: large queries and TDS 7.0 revisited

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Kimsal <michael AT note.themusicguide.com>
  • To: freetds AT franklin.oit.unc.edu
  • Cc: camber AT ais.org
  • Subject: Re: large queries and TDS 7.0 revisited
  • Date: Sun, 22 Oct 100 23:27:03 -0400 (EDT)


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





Archive powered by MHonArc 2.6.24.

Top of Page