4 ms·
smitty1e wrote: > I'd always thought that stronger type systems had to do with performance and storage optimization, but TFA didn't delve into that. I was als
by codesections 5y ago
smitty1e wrote:
> I'd always thought that stronger type systems had to do with performance and storage optimization, but TFA didn't delve into that.
I was also expecting/hoping to see this point addressed.
- 12thwonder 5y agodo you think having a DATE type will increase performance for example as opposed to use INT/LONG type? if stronger type systems will ensure performance, Haskell will beat C in benchmarks but that's not the case in most situations.
- Jweb_Guru 5y agoMany databases benefit significantly from being able to optimize knowing that a column is a fixed-width integer, for instance (or a timestamptz--especially when it comes to sorting and indexing!). SQLite has not historically cared much about these kinds of optimizations because it does not compete particularly well on execution speed with other databases for anything but very simple queries.