I just loaded your sample code in my Studio and compiled it. IMHO %RebuildIndices() should just work. How do you call it?

A hint from me: We've reimplemented %PurgeIndices() as the generated version of ISC deletes the indices very ineffecient - line by line. Our version just kills the appropriate global tree. 

Yes, we can rebuild indices by %BuildIndices(). To rebuild specific, named indices we use  %PurgeIndices(<IndexList>) and  %SQLBuildIndices(<IndexList>)

I think, you have to delete the index definition in the class. For SQL storage it is IMHO sufficient to have the index definition in the storage.

Just the IDKEY index has to be defined in the class.

I have many data mapped like this and Caché usually uses the indices.

To get Caché to use mapped indices you have different options:

1. Use appropriate data types.
2. It looks like the collation of your indexed data is "exact". So please use one of these options  (or a combination of them) if the data type is %String:
   1. Property bbb as %String(COLLATION="EXACT");
   2. select * from loggpro.Indextest where %EXACT(bbb)=123

If all of your indexed data of type %String is collated "exact", it is usefull to subclass the %String datatype and set the COLLATION parameter there. Use the new datatype instead of %String afterwards.

Good luck!

Alex Riemer

Could you post your code and some sample global content you try to map, please?

We did some execution time measurements and had extremely high times in some nested calls compared between two machines. The calls were between some very big routines. The most extreme has its object code splitted to 46 ^rOBJ subnodes and has a total size of >1MB.

You realize the difference only in very long loops (as in the sample above) and deep nested calls to big routines (BTW: classes are compiled to routines too).

The measurements were made on a system with high load so the routine buffer was quickly invalidated by other processes.

I hope this helps.

One more thought: Depending on the call structure of your methos/classmethods it's necessary to increase routine buffers too.

In our case 128 MB was too less. We configure to 256 MB on all production systems and it runs flawless since.

How about using $Name() function?