A Sql Server bottleneck in my Web Search Project?

Ok, not necessarily a bottleneck, but something I wanted to mention.  Indexes are a great thing when used properly.  Over using indexes causes stability trouble, but it also causes file space trouble.  Since I am running my Web Search on my laptop at this time, disk space is at a premium even on a system with 60 gigs of drive space.  Indexes take up some amount of space.  Be careful in using too many indexes.

Wally

1 Comment

  • I have found having one index can result in quicker inserts than not having an index. Possibly due to fillfactor on indexes, i.e. space is all ready allocated and so new pages may not need to be allocated to the table.

Comments have been disabled for this content.