oh.. yes .. Auditing and temporal are two different use cases
- Log in to post comments
All
Accepted answers
is this for the the purpose of auditing datachange ? then why not using the built in auditing function by turning on the audit database for the appropriate events ? Now the SQL Auditing is also available to monitor even data access.
- Log in to post comments
what ODBC driver you are using ? Crystal's or InterSystems? Try using a later/est compatible InterSystems ODBC driver.
- Log in to post comments
Have you tried Interface Explorer from http://www.laconic-designs.com/ ? It used to be a good tool when I tried it sometime back.
- Log in to post comments
Common SQL tools like WinSQL can do that, since Cache is a supported database in WinSQL
- Log in to post comments
Also, using classqueries if possible, can significantly impact your execution time and maintenance overhead.
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY…
All the Best!
Bhaskar
- Log in to post comments
Adding to Ed's comment ( but possibly jumping forward a bit ) , some of the system variables which are often 'NEW'ed and examples can be found here
http://docs.intersystems.com/cache201513/csp/docbook/DocBook.UI.Page.cl…
- Log in to post comments
you may find some books in Amazon too ..possibly good to get you started as an additional resource
https://www.amazon.com/Cach%C3%A9-ObjectScript-MUMPS-Technical-Learning…
- Log in to post comments
Apart from a runaway process, one other activity that often increases the journal by leaps and bounds are bulk data loads, often in an data warehouse/datamart environment. I am sure Tani would cover this use case in his future address about minimizing it.
- Log in to post comments
Ensemble SQL Adaptors are pretty good in syncing. Can that code be used here ?
- Log in to post comments