Posts by Yaniv Ben Malka on InterSystems Developer Community

Question

Yaniv Ben Malka · Nov 6, 2018

Detection of last update timestamp of each class row (DSTIME ?)

Hi,

Most of my classes are mapped from Globals. I want to access Cache classes from a BI software through ODBC connection.

'Last update' information does not exist in most of the classes. My question is whether there is a 'last update' timestamp that is automatically generated for each line in classes I can extract to external systems?

Thanks

#Globals #ODBC #SQL #Caché

0 9

0 751

Question

Yaniv Ben Malka · Oct 10, 2017

Index Recommended Approaches

Hi,

I have a class with around 400k lines and 60 columns. Class storage is Cache SQL storage (Mapped from a global).

I want to create multiple indices on certain fields.

I am familiar with two approaches:

1. Create a new map (Index type) on a pointer global.

2. Create a bitmap index

Which approach is more recommended to be used in the case I described? If there are any other approaches, I will be happy to hear.

Thanks :)

#Globals #Indexing #SQL #Caché

0 11

0 701