DB Table insert vs log which is better for performance
Hi
Which is better to track something, log or DB? frequent and huge data will be updated
Posted: 1 year ago
PEGA
Pegasystems Inc.
FR
Hello,
Difficult to tell you exactly what to do here. What do you want to track exactly? What do you need to store?
Posted: 1 year ago
American Express
American Express
IN
I am thinking of tracking usage of some data instance which is very frequently used and is huge in list.
I want to utilize this to remove un-used/not relevant instance of data type.
I want to be very careful about not impacting the performance as this data type is refered at almost every server interaction.
Posted: 1 year ago
PEGA
Pegasystems Inc.
US
File I/O is usually faster than the DB access. Also Considering DB as a different server, logging operation(I/O) is considered local.