blocks|key|842784|text|Sqlite在更新时锁定整个数据库(除非自从我上次使用它以来，这种情况已经改变了)。第二个线程不能同时更新数据库(甚至使用完全独立的表)。但是，有一个超时参数，它告诉第二个线程在失败前重试x毫秒。我认为ASqlite在数据库组件中显示了这个参数(我认为我实际上编写了这段代码，全部3行，但这是几年前的事了)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|842785|将超时设置为大于0的值将允许多个线程更新数据库。然而，这可能会对性能产生影响。|842786|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Sqlite locks the entire database when updating (unless this has changed since I last used it). A second thread cannot update the database at the same time (even using entirely separate tables). However there is a timeout parameter that tells the second thread to retry for x milliseconds before failing. I think ASqlite surfaces this parameter in the database component (I think I actually wrote that bit of code, all 3 lines, but it was a couple of years ago).

Setting the timeout to a larger value than 0 will allow multiple threads to update the database. However there may be performance implications.

blocks|key|2146937|text|SQLite可以在多线程环境中使用.|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2146938|看看此链接。|offset|length|2146939|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sqlite.org/threadsafe.html^0|0|2|3|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

SQLite can be used in multi-threaded environments.

Check out <a href="http://www.sqlite.org/threadsafe.html" rel="nofollow noreferrer">this link</a>.

blocks|key|2147033|text|火鸟可以在嵌入式版本中使用，但是在本地使用标准(服务器)安装也没有问题。非常小，易于部署，并发访问。使用Delphi很好，您应该将其作为一种选择来研究。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2147034|也见StackOverflow+question+“在Delphi应用程序中使用哪个嵌入式数据库？”|2147035|entityMap|0|LINK|mutability|MUTABLE|url|http://www.firebirdsql.org/|1|https://stackoverflow.com/questions/222699^0|0|2|0|0|P|P|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

<a href="http://www.firebirdsql.org" rel="nofollow noreferrer">Firebird</a> can be used in an embedded version, but it's no problem to use the standard (server) installation locally as well. Very small, easy to deploy, concurrent access. Works good with Delphi, you should look into it as an option.

See also the StackOverflow question <a href="https://stackoverflow.com/questions/222699">"Which embedded database to use in a Delphi application?"</a>

blocks|key|616727|text|自3.3.1版本以来，SQLite的线程需求一直是大放松。在大多数情况下，这意味着它简单地工作。如果您确实需要更多的并发性，最好使用DB服务器。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|616728|entityMap|0|LINK|mutability|MUTABLE|url|http://sqlite.org/faq.html#q6|1|http://www.sqlite.org/threadsafe.html^0|P|3|0|16|5|1|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]|$A|R|B|S|1|T]]|C|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]]]

since version 3.3.1, SQLite's threading requirements have been <a href="http://sqlite.org/faq.html#q6" rel="nofollow noreferrer">greatly relaxed</a>. in most cases, it means that it <a href="http://www.sqlite.org/threadsafe.html" rel="nofollow noreferrer">simply works</a>. if you really need more concurrency than that, it might be better to use a DB server.

blocks|key|2147010|text|SQLServer2008Express支持并发性以及Server的大多数其他功能。而且是免费的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2147011|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

SQL Server 2008 Express supports concurrency, as well as most other features of SQL Server. And it's free.

blocks|key|2147053|text|为什么需要多个线程同时更新它？我确信sqlite将确保正确地完成更新，即使这意味着一个线程等待另一个线程完成；这对应用程序来说是透明的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2147054|实际上，有几个线程并发更新可能对性能没有好处。也就是说，看起来可能有几个线程在并发更新，但实际上结果是更新的完成速度比没有更新的线程慢(因为它们需要持有许多页面锁等以避免出现问题)。|2147055|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Why do you need multiple threads to update it at the same time? I'm sure sqlite will ensure that the updates get done correctly, even if that means one thread waiting for the other one to finish; this is transparent to the application.

Indeed, having several threads updating concurrently would, in all likelihood, not be beneficial to performance. That's to say, it might LOOK like several threads were updating concurrently, but actually the result would be that the updates get done slower than if they weren't (due to the fact that they need to hold many page locks etc to avoid problems).

blocks|key|2147065|text|来自ElevateSoft的DBISAM在多线程模式下工作非常好，并且有自动会话命名以使这很容易。请务必按照“帮助”中关于如何使其安全和完成工作的页面进行操作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2147066|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

DBISAM from ElevateSoft works very nicely in multi-threaded mode, and has auto-session naming to make this easy. Be sure to follow the page in the help on how to make it all safe, and job done.

blocks|key|616876|text|实际上，我目前正在Sybase+ASE上使用多线程Java进程进行性能测试。该过程解析一个1GB文件并将其插入到表中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|616877|一开始我很担心，因为许多高级程序员警告我要注意“表锁定”，以及并发访问DB有多危险。但我继续做测试(因为我想自己找出答案)。|616878|我创建了一个线程，并将其与使用4个线程的进程进行了比较。我只得到了20%25的总执行时间。我使用不同的线程计数和批处理插入大小重新尝试了这个过程。我能挤的最大量是20%25。|616879|我们将很快切换到Oracle，因此我将介绍Oracle在发生这种情况时如何处理并发插入。|616880|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

I'm actually at the moment doing performance testing with a multi-threaded Java process on Sybase ASE. The process parses a 1GB file and does inserts into a table.

I was afraid at first, because many of the senior programmers warned me about "table locking" and how dangerous it is to do concurrent access to DB. But I went ahead and did testing (because I wanted to find out for myself). 

I created and compared a single threaded process to a process using 4 threads. I only received a 20% reduction in total execution time. I retried the the process using different thread counts and batch insert sizes. The maximum I could squeeze was 20%.

We are going to be switching to Oracle soon, so I'll share how Oracle handles concurrent inserts when that happens.

I tried sqlite, 
by using multi-thread, only one thread can update db at the same time..
I need multi-thread updating the db at same time.
Is there are any DB can do the job? 

ps: I use delphi6.

<hr>

I found that sqlite can support multi-threading, 

But in my test of asgsqlite, when one thread inserting, others will fail to insert.

I'm still in testing.

Are there any local DB that support multi-threading?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我尝试了sqlite，通过使用多线程，只有一个线程可以同时更新db。我需要多线程同时更新数据库。有什么DB能胜任这份工作吗？ps:我使用delphi6。我发现sqlite可以支持多线程，但在我对asgsqlite的测试中，当一个线程插入时，其他线程将无法插入。我还在测试中。

问是否有支持多线程的本地DB？
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问是否有支持多线程的本地DB？EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问是否有支持多线程的本地DB？
EN