How many does value of variables insert into the oracle DB in 1 sec ??

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.