CODEWITHSUNDEEP
stringperformancesqlite
Andreas
Andreas

Reputation: 5301

Is SQLite varchar(power-of-2) faster than other sizes?

Are SQLite varchar(power-of-2) generally more efficient?

I think it should be because of alignment with SIMD registers and thereby instructions BUT I´m not sure whether or not they are internally null terminated making power-of-2-minus-one the optimal choice. And even then maybe sqlite does not do anything of above mentioned...

Upvotes: 0

Views: 86

Answers (1)

CL.
CL.

Reputation: 180080

In SQLite's on-disk file format, field values are not aligned.

And:

Note that numeric arguments in parentheses that following the type name (ex: "VARCHAR(255)") are ignored by SQLite.

Upvotes: 2

Related Questions