Skip to content

Multiple insert statements are painfully slow. When stopped, application crashes #3237

@TheSynthMaster

Description

@TheSynthMaster

I was inserting a large number of records via insert statement (importing data from an Oracle DB)

While each sql statement execute in 50-55 ms, only one or two each second are processed, so totally useless for 100k rows.
Moreover, when pressing the stop button, app crashes, the DB is not modified.

Useful extra information

DB4S v3.12.2 [built for x86_64-little_endian-llp64] on Windows 10 (10.0) (winnt/10.0.19045) [x86_64]
using SQLite Version 3.35.5
and Qt 5.12.8

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions