Yes, but as a rule of thumb (in most cases) I don't like having my clustered index on something else than the pk. That's most likely what you'll use to get to your data, which means that if you do put CIX on another column, you open the door to a world of pain in terms of bookmark look-ups.
Just theoritical talk, though. I've never used farcry, thus have no idea how fast it is, or how well it scales. Tof On Mon, Feb 20, 2012 at 3:38 PM, Justin Carter <justin.w.car...@gmail.com>wrote: > On Feb 20, 10:11 am, christophe albrech <christophe.albr...@gmail.com> > wrote: > > But it can have performance implications at the DB level. > > > > - If not sequential, Index fragmentation ensues. Page splits, too. > > - As the UUID is probably the clustering key, it gets added to all > NCIs, > > which in turn become larger and slower. > > - Database gets bigger. That means less stuff in proc and data cache, > > more io, longer backups and disaster recovery procedure. > > > > That said, they are, indeed pretty useful to move stuff around. And using > > sequential UUID does a good job of limiting the damage. No idea what far > > cry does under the hood though, so I'll stop bitching. > > > > Tof > > > FarCry doesn't lock you into anything in this regard, you can avoid > fragmentation and page splits by making objectid a non-clustered index > and setting your clustered index to something more suitable, as you > would do in any database that you needed to tune for performance. For > those content types with millions of rows you'd also set bRefObjects > to false in your component to avoid writing to FarCry's "master" table > of objects and specify the content type name in any ORM related > functions, instead of letting FarCry look it up automatically. > > cheers, > Justin > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To post to this group, send email to cfaussie@googlegroups.com. > To unsubscribe from this group, send email to > cfaussie+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/cfaussie?hl=en. > > -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
