tauri-apps / tauri-apps/plugins-workspace

[sql] select queries are still blocked and not executed concurrently (sqlite)

Open
#2,254 1 comment 0 reactions 0 assignees View on GitHub
plugin: sql type: bug
Dominant language
Rust
Stars
1.8k
Forks
602
Avg merge
4d 14h
Merged PRs (30d)
9

Description

Even with this fix https://github.com/tauri-apps/plugins-workspace/pull/1972 implemented to answer this issue https://github.com/tauri-apps/plugins-workspace/issues/1935, after updating to v2.2.0 this code still executes sequentially and not concurrently.

```
console.time("long");
console.time("short");
// This takes 3 seconds
db.select(
"WITH RECURSIVE cte(x) AS (SELECT 1 UNION ALL SELECT x + 1 FROM cte LIMIT 10000000) SELECT count(x) FROM cte;"
).then(() => {
console.timeEnd("long");
});
db.select("SELECT 1;").then(() => {
console.timeEnd("short");
});
```

> [Debug] long: 3395.504ms (Sandbox.tsx, line 38)
> [Debug] short: 3395.760ms (Sandbox.tsx, line 41)

Is there something I missed?

cc @cijiugechu

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.