odbc导致高mysql服务器负载

I have heard that excel-based ODBC connections can cause high server load (repeatedly warned at least).

我听说基于excel的ODBC连接可能导致高服务器负载(至少反复警告)。

Is this a catch-all disclaimer, or is there a serious issue here? I plan to have 5-8 excel sheets that would be open all day updating one table (with about 65 cells) every minute.

这是一个无所不能的免责声明,还是存在严重问题?我计划每天更新一张桌子(约65个单元格),每天都有5-8张excel表格。

1 个解决方案

#1

I can't imagine it would cause much load.... but surely the best way to find out is to try it in a test environment and monitor the server metrics...

我无法想象这会导致很多负载....但最好的方法是在测试环境中尝试并监控服务器指标......