Is there a way to speedup schema creation for tests?

ScyllaDB
1

I would like to use ScyllaDB as the main database and main task is writing integrated tests for a server application.

Each test should start isolated with a fresh database without data from other tests. This leads to requirement either to create schema per each test, or truncate tables data for each test.

Both schema creation and truncation take relatively long time (each table takes 50-200ms for an operation; more tables we have, more time it takes for each test to run) increasing time for each test to complete.

I’m using testcontainers & 2026.1 ScyllaDB in dev mode with command options ["--developer-mode=1", "--overprovisioned=1", "--smp 1", "--enforce-rack-list 1"]

I also set some options for schema/truncate quries:

var poolOpts = new PoolingOptions();
poolOpts.DisableShardAwareness();
poolOpts.SetWarmup(false);

var queryOpts = new QueryOptions();
queryOpts.SetConsistencyLevel(ConsistencyLevel.Any);
queryOpts.SetDefaultIdempotence(false);
queryOpts.SetPrepareOnAllHosts(false);
queryOpts.SetSerialConsistencyLevel(ConsistencyLevel.LocalSerial);

var mSyncOpts = new MetadataSyncOptions();
mSyncOpts.SetMetadataSyncEnabled(false);

This partially helps to save time, but the time spend in schema-create/truncate still remains valuable relative to test duration.

Does anyone know is there a way to speedup schema creation or data truncation some way for test purposes? May be there is another fast approach for running tests along with data stored in the Scylla database?