Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1944

Re: cluster or hash table advise needed

Show all headers | View raw

On Tuesday, September 29, 2015 at 1:15:20 PM UTC-7, Erland Sommarskog wrote:
> M.G. (michael@gurfinkel.us) writes:
> > We are designing a table with high insert / delete activity. The table
> > maintains sequence of actions per specific experiments. These are the
> > attributes: 
> 
> Important question: is the activity concurrent or not? That is, can data for 
> multiple experiments be written simultaneously?
> 
> > Expected number of records - around 10 million, expected number of
> > inserts (pure additions) around 5000 a day, number of change
> > (delete/insert) around 1000 
> 
your concurrency assumption is correct - not an issue here
thank you for the suggestion.
> OK, so that is not really high activity. :-) 
> 
> And then I would assume that there is no concurrent activity.
> 
> I would say that you scrap the ACTIVITY_SEQUENCE column, as it seems 
> to serve no purpose. Make (EXP_ID, ACT_SEQ, ACT_ID) a primary key, because 
> a having a primary key based on data is a good thing. You may never
> look at indivitual data, but you don't want duplicates. And make
> this PK clustered, that seems to fit your use of the table very well.
> 
> 
> 
> 
> -- 
> Erland Sommarskog, Stockholm, esquel@sommarskog.se

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

cluster or hash table advise needed "M.G." <michael@gurfinkel.us> - 2015-09-29 12:06 -0700
  Re: cluster or hash table advise needed Erland Sommarskog <esquel@sommarskog.se> - 2015-09-29 22:15 +0200
    Re: cluster or hash table advise needed "M.G." <michael@gurfinkel.us> - 2015-09-29 13:55 -0700

csiph-web