SQL LITE是单用户或数据库可以在LAN中共享 [英] SQL LITE is single user or database can be shared in LAN

问题描述

SQL LITE是单用户还是数据库可以在局域网中共享？

SQL LITE is single user or database can be shared in LAN?

推荐答案

SQLite可以支持跨局域网的多个用户， 但 我强烈建议反对它。



这是一个基于文件的数据库系统，因此在写入时锁定文件（正如您所期望的那样） ）并且在写入完成并释放锁定之前，没有其他用户可以访问该文件。这意味着您必须不断编写文件使用中错误并重试，这是一个PITA。此外，当您查询时，整个文件将通过网络连续传输到每个站点，这会对性能产生重大影响。



如果你想要多个同时用户，我建议你使用一个适当的多用户数据库，如SQL服务器或MySql - 从长远来看，它将节省很多延迟和悲伤。

SQLite can support multiple users across a lan, but I would strongly suggest against it.

It is a file based database system, so locks the file when it writes (as you would expect) and no other user can access the file until the write is complete and the lock is released. Which means you will have to code continually for "file in use" errors and retry, which is a PITA. In addition, the whole file will continuously be transferred across the network to each station when you query it, which can have a significant impact on performance.

If you want multiple simultaneous users, I would suggest you use a "proper" multiuser database like SQL server or MySql - it will save a lot of delay, and grief in the long run.

请检查以下链接...

Hi,

Check the following link...

Appropriate Uses For SQLite

[ ^ ]



一个sqlite数据库到多个自动用户 [ ^ ]



问候，

GVPrabu

[^]

one sqlite database to multiple autoit users[^]

Regards,
GVPrabu

这篇关于SQL LITE是单用户或数据库可以在LAN中共享的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！