I think we can manage audit table while still having CREATED_BY, CREATED_TIME,UPDATED_BY, UPDATED_TIME in same tables. So with that approach we may never need to do table scan of audit table while fetching updates. So each updates will recorded in separate table while original table having all relevant information. WDYT?
Thanks, sanjeewa.
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
