You need a multi-proc box, I was told there was a sweet spot for full-text
search on an 8 way by a Microsoft product manager for full-text. You need a
possible for your catalogs with a dedicated controller. Preferably 64 bit
"SenShan" <senthilrajans@yahoo.com> wrote in message
news:1154406688.174631.177910@s13g2000cwa.googlegroups.com...
> Thanx Hillary
>
> Any thoughts on Infrastructure requirment?
>
> Where do i get some metrix on Inrastructure VS Performance VS DB
> Design/Size
> My concern is for 5 million record, how fast the respose will be?,
> what is the suggested Infrstructure?
>
> How do I implement paging? is there any facility in the SQL server ? (
> basically to provide the better response to the client page)
>
>
> Any Input or links/ Weblogs/URLS to this?
>
> Thanx
> -SenShan
>
>
>
> Hilary Cotter wrote:
>> This should work. I trust you are using SQL 2005 as it offers performance
>> benefits over SQL 2000.
>>
>> When you start getting large tables you need to think about partitioning,
>> ideally you would partition according to some criteria which matches your
>> querying restrictions. For example of the majority of your queries are
>> date
>> bases you could have a different table (and catalog) for each year.
>>
>> You will also get better performance by dedicating a catalog to each
>> large
>> table.
>> --
>> Hilary Cotter
>> Director of Text Mining and Database Strategy
>> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>>
>> This posting is my own and doesn't necessarily represent RelevantNoise's
>> positions, strategies or opinions.
>>
>> Looking for a SQL Server replication book?
>>
http://www.nwsu.com/0974973602.html >>
>> Looking for a FAQ on Indexing Services/SQL FTS
>>
http://www.indexserverfaq.com >>
>>
>>
>> "SenShan" <senthilrajans@yahoo.com> wrote in message
>> news:1154329843.708979.54850@i42g2000cwa.googlegroups.com...
>> > Hi
>> >
>> > I have a requiremnt for a Keyword search on 15 fileds on my tables.
>> >
>> > There are 4 tables - Each table has 3 fields of varchar. which needs to
>> > be idexed for full text.
>> > i.e Full text index on 4 tables, each table has index on 3 columns.
>> >
>> > Will there be any issues of this design?
>> >
>> > Please suggest me How could I design this requirment? Is FT is a proper
>> > solution.
>> > If any thought on hanling Paging in the respective ASP.NET Page for
>> > Quicker end user respone.
>> >
>> > Estimated size of DB is 5 Million records. 400 concurrent users - what
>> > is the preferred Infrstructure ( DB configuration), How could we Scale
>> > up as the DB size grows?
>> >
>> > Thanx
>> > -SenShan
>> >
>
