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