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.
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.
oh.. yes .. Auditing and temporal are two different use cases
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.
what ODBC driver you are using ? Crystal's or InterSystems? Try using a later/est compatible InterSystems ODBC driver.
Have you tried Interface Explorer from http://www.laconic-designs.com/ ? It used to be a good tool when I tried it sometime back.
Common SQL tools like WinSQL can do that, since Cache is a supported database in WinSQL
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
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.cls...
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/...
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.
Ensemble SQL Adaptors are pretty good in syncing. Can that code be used here ?