What is the best way to store large text values?

[Andrey Aunmag]

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.

[Andrey Aunmag]

So, I suppose H2 isn't good at this, and it would be better to use an another DB. Can you give me some advice?

[Noel Grandin]

If you're shutting the DB down normally, it should start up pretty quickly.

H2 is unfortunately not great with TEXT/LOB data. At that size you could try storing it in a VARCHAR column.

You'll have to be more specific about what exactly is slow.