dhd415

29 ms·

241.
by dhd415 10y ago
I think there are several useful points here: 1) It's rare to have enough insight into the internals of a particular datastore to accurately predict how it will perform on a particular workload. Whenever possible, early testing on prod
242.
Better SQL joins in CockroachDB(cockroachlabs.com)
22 points by dhd415 10y ago|2 comments
243.
by dhd415 10y ago
I'd say YAGNI applies here since 95% of systems will never need to scale beyond the capabilities of a properly-configured RDBMS. Ensuring consistency and durability with a non-relational, distributed datastore generally requires a lot
244.
by dhd415 10y ago
Yeah, San Antonio is almost certainly a better description of the location. Rackspace's HQ is technically in the incorporated city of Windcrest, but unless you've lived in the San Antonio MSA, you've probably never heard of W
245.
by dhd415 10y ago
Ah, that's an awfully nice search capability. I posted elsewhere in this thread that I use SimpleNote. It's not perfect, but >95% of my note-taking needs were text-only and SimpleNote was less hassle than Evernote.
246.
by dhd415 10y ago
I've heard that it's good, but I never tried it myself. I think OneNote is free now, so I'm pretty sure you could try it without having to buy anything.
247.
by dhd415 10y ago
I don't have any screenshots or other images in my notes. If I needed one, I'd probably upload to an image hosting site and put the URL in my note. That's obviously not as good as embedding inline, but I haven't found an
248.
by dhd415 10y ago
If using Microsoft tools is an option for you, you might consider OneNote. I almost chose it for my use, but wanted something lighter weight.
249.
by dhd415 10y ago
I wanted a tool with some organizational and formatting capabilities and built-in syncing, so I used EverNote up until the point that they limited the number of devices that would work for unpaid plans. I have since switched to SimpleNote.
250.
by dhd415 10y ago
The SQL Server licensing model is "per core", but the minimum licensing increment is 2 cores which costs (2 * $7k = $14k). It's obviously a confusing pricing scheme, but try pricing out Oracle some time!
251.
by dhd415 10y ago
That's the price for a 2-core license pack.
252.
by dhd415 10y ago
It's unclear what you mean about the difficulties of getting data out of SQL Server since it's really no harder or easier than getting data out of any other RDBMS. Scaling SQL Server, just like scaling any other RDBMS, can be chal
253.
by dhd415 10y ago
I suspect your familiarity is with areas that are much higher cost than average. I've owned houses in two different MSAs in the top 25 in the US and the land value was much lower than 80% of the total value. Land value is also very dem
254.
by dhd415 10y ago
From what I've read about CockroachDB, I thought it was master-less. If so, I certainly hope there's a market for a horizontally-scalable, ACID-compliant database. I know it would come in handy for a number of applications I'
255.
by dhd415 10y ago
Did that 40x number come from that video? In my experience, any non-trivial async operation (e.g., a 2ms database insert in a fast OLTP system) is going to be on the order of 10-20% slower in straight-line operation latency than a sync ope
256.
by dhd415 10y ago
>>I would argue that async/await is far more important for native applications. I've seen plenty of apps doing significant work on the UI thread and hanging. Making it easy for developers to run things in the background is g
257.
by dhd415 10y ago
This is very true and a better explanation of the benefits of async/await than "Efficiency and Comfort" from the article. There are a lot of articles on async/await in .NET that use the example of off-loading a long-runn
258.
by dhd415 10y ago
My team has a daily 15-minute scrum meeting that I haven't found overly burdensome. We're spread over a 4-hour time difference, so the time of day isn't really an imposition on anyone. It's also no big deal if someone mi
259.
by dhd415 10y ago
Beyond that, I'd say the ease with which a video chat can be initiated is important so that the annoyance of starting one does not become an impediment to using them when they are appropriate. My team uses Sococo which, while not witho
260.
by dhd415 10y ago
Yes, that capability was restored in Android Nougat. For example, see these Chrome permissions: http://i.imgur.com/D4jYrjP.png
261.
by dhd415 10y ago
I'm a big fan of PG and PG is good enough that it can compare favorably to MSSQL on its own merits, but that article reads more as a screed against commercial software than an objective assessment of PG's strengths relative to MSS
262.
by dhd415 10y ago
You're misinformed about the nature of the SQL Server codebase. While it was originally licensed from Sybase, all parts of it have been completely re-worked. I read somewhere that they celebrated "zero Sybase day" or somethin
263.
by dhd415 10y ago
I've not heard of any. I would imagine that the real value for Microsoft is in expanding the number of server platforms on which SQL Server can run and MacOS doesn't really fall into that category.
264.
by dhd415 10y ago
SQL Server supports heaps (tables w/o clustered indexes) on which indexes point directly to the referenced row. It's nice that they allow you to choose between those and tables with clustered indexes where any secondary index refe
265.
by dhd415 10y ago
Cassandra really isn't a columnstore in the same sense that the word is used for OLAP systems. In the latter, efficient queries can be run across lots of values in a small number of columns across many rows. In Cassandra, queries spann
266.
by dhd415 10y ago
While the licensing details can be somewhat complicated, the retail price of ~$7k/core is published on Microsoft's site at https://www.microsoft.com/en-us/sql-server/sql-server-2016-p... . Oracle's p
267.
by dhd415 10y ago
No, for example, a composite index on (tenant, date) would be highly non-selective whereas an index on date in each individual tenant partition is highly selective and therefore higher-performance (in my case, much higher performance).
268.
by dhd415 10y ago
There are other possibilities as well. For example, if your partitioning strategy is such that it improves the selectivity of an index, it could improve query plans for queries that were on an index that was less selective. As an example, I
269.
by dhd415 10y ago
For many installations, an Aurora read replica can eliminate the need for a multi-AZ master instance which cuts the cost of your master instance in half.
270.
by dhd415 10y ago
I suspect you're right. I wonder if that's part of the reason why they claim a lower performance improvement of 2x over "standard" pgsql installations rather than the 5x improvement of Aurora/MySQL over standard MyS

More ›