Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Anand Jha (ANANDJHA)
American Express
LSA
American Express
IN
ANANDJHA Member since 2010 13 posts
American Express
Posted: Feb 24, 2020
Last activity: Feb 24, 2020
Posted: 24 Feb 2020 12:35 EST
Last activity: 24 Feb 2020 22:51 EST
Closed

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 

To see attachments, please log in.
Low-Code App Development
Lead System Architect

  • Ben Neal Afzal Natheer Durga Charan Tadi
Posted: 4 years ago
Posted: 24 Feb 2020 22:51 EST
Anand Jha (ANANDJHA)
American Express
LSA
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.

To see attachments, please log in.
Posted: 4 years ago
Posted: 24 Feb 2020 15:37 EST
Harish Gunneri (Harish_Gunneri)
PEGA
Senior Principal Engineer, Technical Support
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.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice