Estimate time to populate full text index

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: mustafa jarrar (anonymous_at_discussions.microsoft.com)
Date: 04/23/04 

Date: Fri, 23 Apr 2004 09:36:04 -0700

Can someone give me an estimate time to populate a full-
text index, SQL Server 2000:
-14 million rows,
- each row is about 1 paragraph long. (approx 400 words and is stored in a LONG TEXT field)
- Language of the text: mixed.
- W.H.:a single CPU 2.8GHZ with 2GB Ram and have 300GB disk space
-incremental.

it has been running for 3 days now and who knows where we are...
Any way to speed up..

Thanks

Relevant Pages

  • Re: General .Net Question
    ... I contend very difficult to just jump in and learn, and the SQL Server ... development using Java. ... A/E/C Consulting, Web Design, e-Commerce Software Development ... >> Language Specification). ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: FTS for particular language
    ... John, ... installed SQL Server with Arabic or Latin collation. ... While your default FT Language ... >> regardless of Arabics). ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Why cant recursive queries contain...?
    ... Triggers would be events, stored procs would be functions, views would be linq statements, tables would be collections etc. Imagine writing your application in C# and stepping through code and straight into a C# stored proc ... You can definitely use C# as a front end for a database; in fact, people do exactly this every day when they write .NET Windows and Web client applications. ... C# would probably make a better native language for an object-oriented database as opposed to a database derived from the relational model though. ... "Expert SQL Server 2008 Encryption" ...
    (microsoft.public.sqlserver.programming)
  • Re: Why plural table names? (Celko)
    ... > language, would you name an array of Employee objects 'Employee'? ... Pro SQL Server 2000 Database Design - ... >> I hope you are kidding:) I know you CAN think that way, ...
    (microsoft.public.sqlserver.programming)
  • RE: Stubborn Array wont Populate from single ADODB.Connection Query
    ... Let UserInfo= RecSet.Fields.Item.Value 'Populate value ... 'Find SQL Server data for the active user. ... ReDim DeptDomainAs String ... Dim Conn As ADODB.Connection 'SQL Server Connection ...
    (microsoft.public.excel.programming)