below is architecture of my applications.
下面是我的应用程序的架构。
sensor↔parser app↔database↔application1↔ethernet↔server
application2 and application3 are same level of application1.
application2和application3是相同级别的application1。
database = sqlite3
database = sqlite3
problem is that too many transaction occured on database system.
问题是数据库系统上发生了太多的事务。
parser app and applications are queries whole range of database for checking any differences every second.
解析器应用程序和应用程序是查询整个数据库范围,用于每秒检查任何差异。
so i would like to change architecture or database.
所以我想改变架构或数据库。
is there any database which has better performance than sqlite3? or which part do i have to change?
有没有比sqlite3更好的性能数据库?或者我必须改变哪一部分?
1 个解决方案
#1
0
I would switch out sqlite3 in favor of MySQL or PostgreSQL, those database systems are meant to handle multiple clients where as sqlite3 won't be able to do this because everything is stored in a single file. Each (write) access therefore has to block the entire database instead of only a single row of the table in question.
我会将sqlite3改为支持MySQL或PostgreSQL,这些数据库系统旨在处理多个客户端,因为sqlite3将无法执行此操作,因为所有内容都存储在单个文件中。因此,每个(写)访问都必须阻塞整个数据库,而不是仅阻塞相关表的一行。
#1
0
I would switch out sqlite3 in favor of MySQL or PostgreSQL, those database systems are meant to handle multiple clients where as sqlite3 won't be able to do this because everything is stored in a single file. Each (write) access therefore has to block the entire database instead of only a single row of the table in question.
我会将sqlite3改为支持MySQL或PostgreSQL,这些数据库系统旨在处理多个客户端,因为sqlite3将无法执行此操作,因为所有内容都存储在单个文件中。因此,每个(写)访问都必须阻塞整个数据库,而不是仅阻塞相关表的一行。