I have a problem with memory  when reading from MySQL database


After starting the manager, process winccoactrl.exe
usage the memory is infinitely increasing.
Script trigger: 1 second.

OS Windows server 2019
WinCC OA v3.18 P012
Mysql 8.0

Test Code :

#uses "CtrlADO"
main()
{
int rc;
dbConnection conn;
string conStr = "DSN=DB_MySQL";
// ODBC
rc = dbOpenConnection(conStr,conn);
//SQL
string  queryStr = "SELECT * FROM Station";
//rs
dbRecordset rs;
//SQL
rc = dbOpenRecordset (conn, queryStr, rs);
if (!rc)
{
while (!rc && !dbEOF (rs))
{
anytype id,name,addr;
rc = dbGetField (rs, 0, id);
rc = dbGetField (rs, 1, name);
rc = dbGetField (rs, 2, addr);
DebugN(id,name,addr);
rc = dbMoveNext (rs);
}
dbCloseRecordset (rs);
}
dbCloseConnection(conn);
}


Thanks

qwertyJH

Does it also happen with other applications using the same ODBC connection?

You could also try to use the more efficient 'rdbSelect' or 'dbGetResult' functions.

No, other apps work fine (wincc vbs script)

I'll try functions 'rdbSelect' and 'dbGetResult'.

Thanks