branko_d

32 ms·

361.
by branko_d 6y ago
Neo: What are you trying to tell me? That I can dodge "call rax"? Morpheus: No, Neo. I'm trying to tell you that when you're ready, you won't need "call rax". --- Compiler has access to optimizations that
362.
by branko_d 6y ago
I remember that about Amiga. Everything was just smooth. I still have fond memories of Cygnus editor being super-responsive to anything I could throw at it, even with SAS C running in the background. I was taken aback by how slow Windows 95
363.
by branko_d 6y ago
From https://www.ottoaviation.com/technology "The design of the Celera fuselage takes advantage of an optimum length-to-width ratio to maximize laminar flow. These benefits will not scale for large jet transports and a
364.
by branko_d 6y ago
> but, weirdly, can't "SELECT * FROM A_Index". In all honesty, most DBMSes have some sort of "hinting" mechanism that accomplishes roughly the same. It's a cludge, though, usually in the form of specially fo
365.
Why Some Apps Are Intentionally Slow(youtu.be)
1 points by branko_d 6y ago|0 comments
366.
Whiteboard coding interviews are 'anti-women psychological stress examinations'(theregister.com)
5 points by branko_d 6y ago|0 comments
367.
by branko_d 6y ago
From the article: > Visualizing something, in three dimensions, can help you with a concrete “hook” that your brain can grasp onto and use as a model; understanding then has a physical context that it can “take place in”. I'm still
368.
by branko_d 6y ago
The pixels are self-emitting (similar to OLED).
369.
by branko_d 6y ago
> Everything I develop on it screams on anything modern. This is a very good point. I think the user experience, on average, would be quite a bit better if developers weren’t so prone to chasing glitzy new hardware that can “mask” perfor
370.
by branko_d 6y ago
> I think we're stuck with expensive repeated query planning. I agree with that (sadly). I'd like to see more expressive SQL, but I'm not saying it will make the situation with planning any better. I'd argue it should
371.
by branko_d 6y ago
> I'm afraid there is - time and space. Sure, I'm well aware of that. I did say "in principle", after all. However, we are generating multiple plans already by changing the SQL text (by concatenating-in the table name
372.
by branko_d 6y ago
> Reason for most of these is the optimiser. Well, optimiser as currently implemented, tying only one plan to each uniqe SQL text. There is nothing, in principle, preventing an implementation that produces multiple plans based on the par
373.
by branko_d 6y ago
SQL Server's inline table-valued functions are a good start. They are essentially parametrized views, which are inlined and "disappear" at the point of use, so all the usual transformations are available to the query optimize
374.
by branko_d 6y ago
> My first schema designs didn’t even have relations. I'm pretty sure your first schema designs had relations (tables). I can't speak for relationSHIPS (foreign keys) though... ;)
375.
Scientists Create a Pattern That Is Impossible to Duplicate(scitechdaily.com)
1 points by branko_d 6y ago|0 comments
376.
by branko_d 6y ago
> large numbers of sterile insects are released to reduce the population This has been done successfully on the flash-eating screwworm: https://www.theatlantic.com/science/archive/2020/05/flesh-ea...
377.
by branko_d 6y ago
> If you have an index on <companyId, userId>, and you query with a userID only, that index wont be used. Surprisingly, it could be used in some circumstances, just not for the regular seek. If the index is small (compared to the b
378.
People Use Chalk to Write Plant Names on Sidewalks to Help Connect with Nature(goodnewsnetwork.org)
3 points by branko_d 6y ago|1 comments
379.
by branko_d 6y ago
If you are an application programmer needing to query the database, I wholeheartedly recommend "SQL Performance Explained" by Markus Winand, or his website: https://use-the-index-luke.com/
380.
Doctors in Paris believe coronavirus may have been in Europe in late December(cbsnews.com)
3 points by branko_d 6y ago|0 comments
381.
by branko_d 6y ago
On the other hand, the importance of a specific task can sometimes be adequately assessed only by a narrow group of people, making it difficult to convey the importance to the larger organization. This usually falls in the realm of performa
382.
by branko_d 6y ago
There is a third way: keep the data pre-sorted in the database (via an index).
383.
by branko_d 6y ago
SQL Server can index a computed field, which is more-less the same thing.
384.
Heat Pump Water Heaters(energy.gov)
157 points by branko_d 6y ago|214 comments
385.
Small Promises Regularly Kept(cutle.fish)
1 points by branko_d 7y ago|0 comments
386.
by branko_d 7y ago
> more people are immune due to prior infection This is not a given. Other coronaviruses tend to confer only temporary immunity, and this one might be similar. This thing could become seasonal unless/until we make a very effective v
387.
by branko_d 7y ago
No, "theory" is simply a provable "hypothesis". Doesn't have to be proven, just provable. The thing is, a theory can never be completely proven. We can never completely discount the possibility of making a new obser
388.
Mysterious heart damage, not just lung troubles, befalling Covid-19 patients(khn.org)
255 points by branko_d 7y ago|188 comments
389.
by branko_d 7y ago
It's not just about bugs. Static typing is crucial for productivity whenever the codebase overflows your brain's working memory. Navigating through code, refactoring, or simply figuring out what to pass as function input can becom
390.
by branko_d 7y ago
Could this be used for glasses? Could the same glasses serve both as reading glasses and as long-distance glasses?

More ›