SigmundA

93 ms·

901.
by SigmundA 6y ago
B-trees have little to do with it, if the table has many columns its cheaper to scan the index for the value because it occupies less pages, thats all, less I/O more cache hits etc, goes from top to bottom on the index scanning for the
902.
by SigmundA 6y ago
Yes every row of the index needs to be scanned not every row of the table which is faster than scanning the table. I am most familiar with MS SQL server and it will most certainly do an index scan for what it thinks is a highly selective
903.
by SigmundA 6y ago
Depends on estimated selectivity and if the index covers the result as well. If the criteria would fetch few rows out of many it can be faster to scan the index then retrieve the few matching results and even better if the index covers the
904.
by SigmundA 6y ago
Pedantically if your database supports index scans it can use the index on the column to scan for '%abc' rather than the whole table which can be much faster while not as a fast as a seek. It can only do a seek if there are charac
905.
by SigmundA 6y ago
Xquery and Linq both use FLWOR like syntax which puts the "FROM" first and helps auto complete, wish SQL had ordered things this way: https://en.wikipedia.org/wiki/FLWOR SELECT first_name FROM person WHERE fi
906.
by SigmundA 6y ago
>LIKE compares characters, and can be paired with wildcard operators like %, whereas the = >operator compares strings and numbers for exact matches. The = can take advantage of indexed columns. Unless this specific to certain database
907.
by SigmundA 6y ago
I am not a fan of Thiel in general but China has the majority of Bitcoins hash rate last I checked and if the maximalist dreams come true with debasing USD while BTC gains relative value then that is a lot of leverage, no?
908.
by SigmundA 6y ago
Lets not forget the column casing issue, you either get columns to match your apps casing and have to quote them everywhere or live with them being lower cased automatically. https://dev.to/lefebvre/dont-get-bit-by-post
909.
by SigmundA 6y ago
The problem is something changed at a random time in a production db on the weekend in the middle of the night, what changed, is that logged somewhere? Other databases show that you can have the planner decide if you don't specify but
910.
by SigmundA 6y ago
Right db developers decide what indexes to add but aren't allowed decide if and how they are used. Join order / type and which indexes to use would go a long way, thats pretty much all I need to do on MSSQL server if the planner i
911.
by SigmundA 6y ago
Probably got enclosed in a dyson sphere.
912.
by SigmundA 6y ago
Yes having worked with MS SQL Server for many years then taking a look at PG the first thing that really surprised me was lack of hints. Having been through similar situations with MSSQL but being able to force it to do the right thing was
913.
by SigmundA 6y ago
This is how motorhomes are made to this day. If you buy a gas Class A coach new it is made on a Ford F53 chassis while the body is made by any number companies completely different. If it’s a diesel it going to most likely be a Frieghtliner
914.
by SigmundA 6y ago
Yes transform may rasterize the content in order to transform it say as a GPU operation this is regardless of printing, this will be noticeable as blurry text and vectors on HiDpi displays.
915.
by SigmundA 6y ago
Because it is a full headless web browser (older version of Webkit).
916.
by SigmundA 6y ago
Chrome definitely does not render text or other vectors like SVG as an image. I just tried printing the Hacker News front page to PDF in Edge which is the same engine as Chrome and the text was selectable.
917.
by SigmundA 6y ago
Wkhtmltopdf is based on QtWebkit which is long deprecated. There was work to move it QtWebEngine but doesn't seem to be going anywhere: https://wkhtmltopdf.org/status.html In the meantime Chrome added headless support
918.
by SigmundA 6y ago
Prince is the only browser engine that fully supports the print css standards that I know of. There seems to be little incentive by the browser makers improve printable output so Prince has quite a niche.
919.
by SigmundA 6y ago
No it would be closer to the Jet db engine that Access uses, they are both file based in process relational db engines. Back in the day for a Windows app if you wanted a in process file based db you would use Jet since the engine was includ
920.
by SigmundA 6y ago
Yes I did misunderstand and that may work to get around the NX restriction being per process it would probably be a significant change to the JIT architecture in order for it to work out of process. This also would probably have security i
921.
by SigmundA 6y ago
So have there ever been vaccines that prevent you from getting getting the disease while still allowing you to spread it? This is a genuine question.
922.
by SigmundA 6y ago
Right so if you are vaccinated you are no longer a carrier and cannot infect those who are not vaccinated. If enough people get vaccinated they act as a barrier between the carriers and the unvaccinated, hence herd immunity.
923.
by SigmundA 6y ago
If vaccinated people can still spread the virus why would a "critical mass" of vaccinations change anything? Herd immunity relies on the fact that either having been vaccinated or recovered from the disease prevents you from sprea
924.
by SigmundA 6y ago
There is variation, some balds are bigger too especially more north. Generally though the two are almost identical in size: https://www.avianreport.com/bald-eagle-wingspan-versus-birds...
925.
by SigmundA 6y ago
Which is fine if you're doing an HTML UI (PhoneGap) since the DOM and JS engine share the same process. If you're doing a native UI with JS then it must marshal cross process to affect the UI then you have to decide which is wors
926.
by SigmundA 6y ago
Out of process mean a loss in performance itself due to marshaling cross process calls and data. When your dealing with UI orchestration its probably better / faster to run an interpreter with no cross process overhead than a JIT with
927.
by SigmundA 6y ago
Unfortunate but I was surprised Apple looked like they where changing it at all since it would lessen security allowing some common attack vectors. I haven't followed it for some time however, it does look like V8 supports a JITless mo
928.
by SigmundA 6y ago
Beyond any TOS issues there has always been a technical issue where an app store app cannot write to memory that is marked executable for security purposes. This prevents JIT's but does not prevent an interpreter from functioning since
929.
by SigmundA 6y ago
From Wikipedia: "After proposing the vehicle's design, and presenting the analysis to demonstrate its viability, the Blackbird team learned that others had previously conceived and built similar designs—most notably aerodynamics e
930.
by SigmundA 6y ago
Synology with Dahua cameras. https://ipcamtalk.com is the place to go for good info.

More ›