Jd
I know nothing about J and JSoftware, but this reads like an Aprils fools joke. Is it?<p>&gt; In a naive system the application has to read every single byte of data from the disk. ... To answer this simple question all the data had to be read from disk. This is a performance disaster and that is where decades of adding bandages and kludges started. .... Think about the earlier query for license and color. Jd gets the license numbers from disk (a tiny fraction of the database)<p>Ofcourse that data has to be read from disk. Well, for simple or aggregate queries he may gain performance. Moreover, as other commenter has commented, you can organize data in columns in MSSQL too for aggregations: <a href="https:&#x2F;&#x2F;docs.microsoft.com&#x2F;en-us&#x2F;sql&#x2F;relational-databases&#x2F;indexes&#x2F;columnstore-indexes-overview?view=sql-server-ver15" rel="nofollow">https:&#x2F;&#x2F;docs.microsoft.com&#x2F;en-us&#x2F;sql&#x2F;relational-databases&#x2F;in...</a><p>&gt; columns used in queries are likely already in memory and the query runs at ram speed, not the sad and slow disk speed. ... Jd performance is affected primarily by ram. Lots of ram allows lots of rows<p>Any other RDBMS can have sensible indexes that satisfy your queries. And, surprise, your data also lives in RAM once you read it.<p>&gt; You can backup a database or a table with standard host shell scripts, file copy commands, and tools such as tar&#x2F;gzip&#x2F;zip.... If you understand backing up file folders, then you pretty much understand backing up Jd databases.<p>And... throw data consistency out of the window?<p>I&#x27;m reading and I&#x27;m &quot;not getting&quot; the selling point - why is this better?<p>Okay, I read that things are files. SQLite is also a file if physical format is a concern.