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

Re: cluster or hash table advise needed

X-Received	by 10.140.150.206 with SMTP id 197mr89610qhw.0.1443560159787; Tue, 29 Sep 2015 13:55:59 -0700 (PDT)
X-Received	by 10.182.52.132 with SMTP id t4mr388obo.25.1443560159498; Tue, 29 Sep 2015 13:55:59 -0700 (PDT)
Path	csiph.com!optima2.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!z77no6299279qge.1!news-out.google.com!z4ni6187ign.0!nntp.google.com!kq10no13907770igb.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Tue, 29 Sep 2015 13:55:59 -0700 (PDT)
In-Reply-To	<XnsA524E262AB726Yazorman@127.0.0.1>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=71.95.163.250; posting-account=99cyNgoAAAA03l-zLDrnoY7TEbs-AvM9
NNTP-Posting-Host	71.95.163.250
References	<fa7449c7-daca-4a6d-81ba-603063464b4f@googlegroups.com> <XnsA524E262AB726Yazorman@127.0.0.1>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<c4b58915-793d-47e9-ae62-08ff26dfcd14@googlegroups.com> (permalink)
Subject	Re: cluster or hash table advise needed
From	"M.G." <michael@gurfinkel.us>
Injection-Date	Tue, 29 Sep 2015 20:55:59 +0000
Content-Type	text/plain; charset=ISO-8859-1
Xref	csiph.com comp.databases.ms-sqlserver:1944

Show key headers only | 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