I have a table which contains large JSON text, each row is about 100 KB. So
entire database file may grow up to 15 GB, which makes it very slow, it
even takes forever to open the database. Despite the fact that c_data is a
CLOB column.
create table t_data (
id integer auto_increment not null,
c_some_column_1 integer,
c_some_column_2 integer,
c_data text,
constraint pk_t_data primary key (id)
);
Am I doing something wrong? Should I store the data in separate text files
to keep DB as lightweight and quick as possible? Are there better solutions?
I use H2 database 1.4.197.
--
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 view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/20177cba-96df-4cec-bbb0-6c938a7b08fa%40googlegroups.com.
