freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

RE: [freetds] Speed and Database performance

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: Thu, 17 Feb 2005 16:09:56 +0100

>
> Hi, thanks for all your help with this,
> Can you tell me where I can find out more about
> persistance connections please?

See PHP manual

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

freddy77

[freetds] Speed and Database performance, Shane Healy, 02/16/2005
- <Possible follow-up(s)>
- RE: [freetds] Speed and Database performance, ZIGLIO, Frediano, VF-IT, 02/16/2005
  - RE: [freetds] Speed and Database performance, Shane Healy, 02/16/2005
- RE: [freetds] Speed and Database performance, ZIGLIO, Frediano, VF-IT, 02/16/2005
  - RE: [freetds] Speed and Database performance, Shane Healy, 02/16/2005
- RE: [freetds] Speed and Database performance, ZIGLIO, Frediano, VF-IT, 02/17/2005
  - Re: [freetds] Speed and Database performance, James K. Lowden, 02/17/2005
- RE: [freetds] Speed and Database performance, ZIGLIO, Frediano, VF-IT, 02/18/2005