想要使用WMI和Sqlite扩展性能 [英] Want to scale the performance with WMI and Sqlite

问题描述

大家好，



我有问题要在提案前弄清楚。



我们有一个软件已经存储了WMI中的元素数据（单个文件记录）。当它做的时候 - 观察到交易的实际时间大约是28秒。我想提高速度..完整交易的时间是15秒。如果我介绍Sqlite日志记录，它会更好吗？我会在日志之前滚动大小检查，如100 MB。



sqlite会比WMI提高性能吗？



问候，

Subbu。

Hi All,

I have question to get clarified myself before a proposal.

We have a software which is already storing a data of elements in WMI (single file logging). When it is doing - observed the actual time for a transaction is about 28 Sec. I would like to increase the speed ..ideal time is 15 secs for a complete transaction. If I introduce Sqlite logging, will it be better ? I will do roll over the size check like 100 MB before log.

Will sqlite gives performance improvement than WMI ?

Regards,
Subbu.

推荐答案

用于记录的WMI？我听过最糟糕的主意。如果WMI对Windows环境意味着什么，请 Windows Management Instrumentation [ ^ ]，而不是用于记录任何类型。我很确定sqlite是更好的选择。

如果日志记录是事件记录而不是数据获取（如SCADA历史数据），那么我建议你使用像这样的记录库。 NLog [ ^ ]，有几个事件写入，如文本文件，但您也可以登录SQLite（参见： http://softwarelounge.co.uk/archives/1611 [ ^ ]）。

SQLite非常强大两个目标，您可以对其进行微调以满足您的总体要求。

WMI for logging? Worst idea I ever heard. If WMI is what it means to me in Windows environment, Windows Management Instrumentation[^], than it is not meant for logging whatsoever kind. I am pretty sure sqlite is much better option.
If logging is event logging and not data acquisition (like SCADA historical data), than I suggest you use a logging library like NLog[^], which has several event writes like text file, but you can also log to SQLite (see: http://softwarelounge.co.uk/archives/1611[^]).
SQLite is really powerful for both targets, and you can fine-tune it to meet your overall requirements.

这篇关于想要使用WMI和Sqlite扩展性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！