![]() If you’re experiencing Relativity pains, drop us a line.īrent says: For a refresher on this app and how we work with it, check out our past posts on The SQL Server Components of kCura Relativity, Performance Tuning kCura Relativity, Using Partitioning to Make kCura Relativity Faster, and Tiering Relativity Databases. I am thrilled to be able to work with my favorite product again. You have users bulk loading thousands to millions of documents, users updating records during review, and then searches running on top of all that. why is that button red.Watch the latest video from Original Smoothin (smoothin). Hi, i am a young content creator hey psst. And all those ascending keys? SQL Server is gonna make some real bad judgement calls on those, especially prior to 2014. Original Smoothin (smoothin) on TikTok 437 Likes. Fragmentation may not matter if you’re reading 1500 pages instead of 1000 pages, but it can sure as heck matter when you’re reading 1,500,000 pages rather than 1,000,000 pages. Index and statistics maintenance can be super important, too. You have 100 terabytes of data and you need to check it for corruption weekly. The challenges that you’re presented with at scale are immense. Not last call for alcohol standards, either. My other favorite part about Relativity is that they have standards. If you’re a DBA who has watched performance tank because some new search suddenly started scanning the clustered index of your 50 million row, one terabyte Documents table with a wildcard search on Email Body and Email Subject and Email Sender and Email Recipients and Email Metadata for ‘insert super common word here’, I feel your pain. Every case is different, and they often need custom indexes. You can’t fix every saved search and workflow immediately, which makes right-sizing hardware super important, but that’s not the only thing. ![]() If you’re a DBA who has read the execution plan of a Relativity query where saved searches reference saved searches that reference saved searches that… you get the point! I feel your pain. You give lawyers this crazy interface that lets them build just about any search query they can dream of, including some really, really bad ones, and see how SQL Server reacts. The customer support is aces (Hello, Pod One), and the developers are super helpful and responsive. Not just because many of the databases I worked with under the software were hundreds of gigs, on up to 9 terabytes, but because the people behind the software really do care about the product. I also started running down the clock on being able to work with my favorite piece of software again. And part of the calendar year fell during a leap year, which was just plain cruel, like a two part Buffy episode where the second part is the first episode of the next season DAMN YOU JOSS WHEDON!Īnyway, I started working here, annoying you guys with blog posts, giving Doug rub-downs in between video takes, and walking Ernie when the Ozar family was too full of illegal caviar and albino truffles to move. Who knows when this thing will get published? Only God and Brent.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |