Caché

Subscribe to Caché content with RSS Syndicate content or email

how to release memory for process?

hi

  I query large mount of rows from one table with JDBC, and will prompt <store> error.  I found that it was out of process memory (default 16M, max 49M in version 2010.2) .

views

rating

MonCaché - Caché as MongoDB

MonCaché — MongoDB API implementation based on InterSystems Caché

 

views

rating

Cursor placement

Greetings,  

views

rating

Problem with setting a property

Hi!

While i am trying to write a data i am getting a error as "<PROPERTY DOES NOT EXIST>zFile+15^User.zKQRest.1 *value,%Collection.ListOfObj" but there are values stored in it. How can i break it write it separately.

views

rating

What is the most efficient way to store/retrieve the data into/from global

Type 1:

^global(key1,key2,key3,val1) = ""
^global(key1,key2,key3,val2) = ""
^global(key1,key2,key3,valn) = ""

Type 2:

views

rating

Visualizing the data jungle -- Part I. Let's make a graph

This is the first article of a series diving into visualization tools and analysis of time series data.

views

rating

ODBC to Cache with Dynamic Table Names

Hello! So, my knowledge on the Cache database is extremely limited, and I was hoping I could find some assistance here. I'm connecting to the DB via ODBC.

views

rating

Trigger a class compilation

Hi all,

 

I was wondering if there is any way to trigger the compilation of a class based on the compilation of another (unrelated) class. For example:

Class 1 = test.class

views

rating

How to configure the size for global buffer

Below are the output messages when Cache start.

Allocated 178MB shared memory: 1MB global buffers, 26MB routine buffers

views

rating

How to dynamically change the entry defined in SQL storage map

I have a class and I would like to dynamically change its selectivity attribute in run-time and then call $system.OBJ.Compile to

views

rating

How to encrypt column value in sql?

hi

   I want to update  some columns in one table like this:

 

    update table1 set col1=%SYSTEM.Encryption_AESCBCEncrypt(col1, 'key')

 

but the error is 

 

views

rating

Is there a function for convert string to hex?

hi

  is there a built in function for convert string to hex.  for example

 

"abc"   convert to "616263"

 

 

thanks

views

rating

Use a global stored in variable.

Greetings, 

How can I store a global name in a variable, ie: x="^G" and then use x like this, as if it were the global:  y=$o(x)  ?

Please advise,

Thanks... 

views

rating

Globals - Magic swords for storing data. Sparse arrays. Part 3.

In the previous parts (1, 2) we talked about globals as trees. In this article, we will look at them as sparse arrays.

A sparse array - is a type of array where most values assume an identical value.

In practice, you will often see sparse arrays so huge that there is no point in occupying memory with identical elements. Therefore, it makes sense to organize sparse arrays in such a way that memory is not wasted on storing duplicate values.

In some programming languages, sparse arrays are part of the language - for example, in J, MATLAB. In other languages, there are special libraries that let you use them. For C++, those would be Eigen and the like.

Globals are good candidates for implementing sparse arrays for the following reasons:

views

rating