I need to consume the content of ^SPOOL output over SQL.
^%SPOOL utilities don't look so promising
This is more a WARNING than a question
I have a class to track data changes.
As it becomes slower and slower to find last changes I think I need an index.
The 2 classes are just simplified reality.
HowTo ?
Class Rick.ChangeItem Extends %SerialObject
{
Property Subject As %String;
Property Author As %String;
Property Change As %TimeStamp;
}
{
Property Subject As %String;
Property Author As %String;
Property Change As %TimeStamp;
}
and
Class DC.listItem Extends (%Persistent)
{
Property Title As %String;
Property Changes As List Of Rick.ChangeItem ;
/// where & how create the index ?
}
{
Property Title As %String;
Property Changes As List Of Rick.ChangeItem ;
/// where & how create the index ?
}