Skip to Content.
Sympa Menu

freetds - RE: [freetds] Speed and Database performance

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Speed and Database performance
  • Date: Fri, 18 Feb 2005 14:15:09 +0100

>
> 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




Archive powered by MHonArc 2.6.24.

Top of Page