How many does value of variables insert into the oracle DB in 1 sec ??
Hi, All
Using a zenon supervisor 7.10 64bit in HP server 2008. and Oracle 11g
and now, updating the data(value of variables) into DB via a zenon Gateway.
but, as many as increasing, getting down the speed of updating .
i think, 600 row may be maximum per 1 sec.
question 1. How may does value of variables insert/update into the DB every 1 sec ?? (maximum)
in fact, i want that more than 16,000 data to be updated into DB every 1 sec.
So, I am going to alter zenon Gateway to vba query like as follow,
100 data per 1 row. ( 100 data is 1 array on online-variables) - increasing the column.
is it possible ??
question 2. if yes, let me know the query ??
question 3. if not, let me know other way How to insert / update the 16,000 data into DB ??
Thanks
This is a migrated post! Originally posted on 10.05.2017 by user gyu. Please be aware that information can be outdated.