Re: Need help with full-text performance for large database

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: John Kane (jt-kane_at_comcast.net)
Date: 06/22/04 

Date: Mon, 21 Jun 2004 23:16:14 -0700

Phil,
Sorry for the late reply... I've started a new job and it's keeping me
somewhat busy... :-)
Yes, Yukon or now officially known as SQL Server 2005 Full Text Search will
be significantly faster in FT Indexing (order of magnitude improvement) and
on the FT Search query side, between 30 & 50% improvement in query times
relative to SQL Server 2000.

Regards,
John

"Phil Sherrod" <phil.sherrod@REMOVETHISsandh.com> wrote in message
news:066dnRBCquz8iFPdRVn-vw@giganews.com...
> John,
>
> I thought of one more question:
>
> Do you know if there are significant performance improvements in full-text
> indexing in the Yukon SQL server that is being field tested?
>
> --
> Phil Sherrod
> (phil.sherrod 'at' sandh.com)
> http://www.dtreg.com (decision tree modeling)
> http://www.nlreg.com (nonlinear regression)

Relevant Pages

  • Re: Printing the KEYS of all tables
    ... the internal architecture of SQL Server and may change from release to ... or that code that access system tables will not work in Yukon. ... catalog views regardless. ... the understanding of metadata. ...
    (microsoft.public.sqlserver.programming)
  • Yukon:Regress or progress - you decide
    ... "SQL Server "Yukon" now has a robust development environment that allows ... only learned what they need to know in order to coexist with the database. ... employees and their managers, and those managers' managers, etc.... ...
    (microsoft.public.sqlserver.programming)
  • Re: Yukon Stability
    ... the SQL Sever 2005 (Yukon) FT Indexing performance gains are very ... significant and order-of-magnitude better than SQL Server 2000. ... >> talked to Microsoft to get addition support using a beta product, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Is Interbase still thriving?
    ... With Yukon, Oracle and IBM are ... I have used Oracle, Interbase, as well. ... SQL Server and MS Access for desktop application. ... I used to work on VMS / and OpenVMS from DEC. ...
    (borland.public.delphi.non-technical)
  • Re: FullText catalog of wss - SQL 2000
    ... My idea was that if WSS doesnt add the catalogs properly in Yukon no ... But i can manually do what WSS does with Sql Server 2000 wrt to ... Best regards, ...
    (microsoft.public.sharepoint.windowsservices)