Yazılım
5 üye · 1 yeni gönderiTakip
Yazılım dünyası ile ilgili paylaşımlar
"As a developer, you may think that your job is to write code.
I disagree. A developer’s job is to solve a problem through software, and coding is just one aspect of software development. Good design and communication are just as important, if not more so."
| Scott Wlaschin
"Language models are, at their core, just mathematical functions."
| Andriy Burkov
Yazılımcılar, müşterilere hayal gücünün somut ürünlerini satar.
Sayfa 15Kitabı okuyacak
In addition, debugging can be an enjoyable activity that shares the thrill of the hunt and chase found in a good detective novel or video game. On the other hand, a protracted, unsuccessful search for a bug in your code quickly loses its charm, particularly when your boss is asking repeatedly about your (lack of) progress. Learning to debug well is essential to enjoying software development.
Clustered Index
In some situations, the extra hop from the index to the heap file is too much of a performance penalty for reads, so it can be desirable to store the indexed row directly within an index. This is known as a clustered index. For example, in MySQL’s InnoDB storage engine, the primary key of a table is always a clustered index, and secondary indexes refer to the primary key (rather than a heap file location)
In SQL Server, you can specify one clustered index per table
“The key in an index is the thing that queries search for, but the value can be one of two things: it could be the actual row (document, vertex) in question, or it could be a reference to the row stored elsewhere. In the latter case, the place where rows are stored is known as a heap file, and it stores data in no particular order (it may be append-only, or it may keep track of deleted rows in order to overwrite them with new data later). The heap file approach is common because it avoids duplicating data when multiple secondary indexes are present: each index just references a location in the heap file, and the actual data is kept in one place.”
Sayfa 91Kitabı okuyor