FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

> 
> On Thu, 17 Feb 2005 16:09:56 +0100, "ZIGLIO, Frediano, VF-IT"
> <Frediano.Ziglio AT vodafone.com> wrote:
> > > Are there any methods
> > > to optimise a MSSQL database for speed?
> > > 
> > 
> > I'm not a very expert mssql administrator. Look at your 
> query and see if
> > indexes/full search can help.
> > 
> > You time it's very short so a network capture and analisy 
> can help you
> > to detect it time is spent in connection or on query.
> 
> Let me second that.  TDSDUMP shows the precise time each 
> packet is sent to
> and received from the server.  Use that to find the source of 
> the delay. 
> In most database environments, query processing constitutes 
> the largest
> part of response time.  
> 
> If you have not, for instance, clustered your indexes or 
> otherwise created
> indexes optimal for supporting your time-critical queries, 
> you should.  I
> have often seen a 10-fold performance improvement from indexing.  For
> large data sets (not typical in a web environment) the 
> difference can be
> one of seconds instead of days.  
> 
> Your DNS optimization, by contrast, is very small.  Name-to-address
> resolution is used only to form the initial connection, and 
> is sub-second
> in a reasonable environment.  
> 

You are right, however Shane see a difference of 0.9 seconds in a web
page that took 0.4. I don't think that query are too complicated...

freddy77