I'm storing millions of hash values in an indexed column of type binary and
is struck by slow inserts because of the random nature.
Are there any tricks to gain better performance?
Is binary the best data type in this situation?
CREATE TABLE file_chunck
(
id IDENTITY PRIMARY KEY
, hash BINARY(16) NOT NULL
);
CREATE unique INDEX i_file_chunck_hash ON file_chunck(hash);
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
