Caché

most votesmost activeno answerunansweredall
Subscribe to Caché content with RSS Syndicate content or email

how to release memory for process?

Caché

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) .

wx fg's picture
Post by wx fg 2 days ago.

views

rating

MonCaché - Caché as MongoDB

APIs, Caché, Caché Objects, Data Model, Document, Databases, JSON

MonCaché — MongoDB API implementation based on InterSystems Caché

 

Maks Atygaev's picture
Post by Maks Atygaev 2 days ago.

views

rating

Cursor placement

Beginner, Caché

Greetings,  

Russell Knight's picture
Post by Russell Knight 10 hours 39 min ago.

views

rating

Problem with setting a property

Beginner, Caché, Caché Objects, Caché ObjectScript (COS)

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.

Kishan Ravindran's picture
Post by Kishan Ravindran 11 hours 57 min ago.

views

rating

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

Caché

Type 1:

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

Type 2:

CM Wang's picture
Post by CM Wang 15 hours 31 min ago.

views

rating

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

Caché, Caché Objects, Tools, Ensemble, Python, VIsualization

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

Fabian Haupt's picture
Post by Fabian Haupt 20 January 2017.

views

rating

ODBC to Cache with Dynamic Table Names

Caché, SQL

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.

Barry Davis's picture
Post by Barry Davis 2 days ago.

views

rating

Trigger a class compilation

Caché, Studio

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

Maarten Van den Vreken's picture
Post by Maarten Van den... 2 days ago.

answers

views

rating

How to configure the size for global buffer

Caché

Below are the output messages when Cache start.

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

CM Wang's picture
Post by CM Wang 4 days ago.

views

rating

How to dynamically change the entry defined in SQL storage map

Caché

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

CM Wang's picture
Post by CM Wang 2 days ago.

answers

views

rating

How to encrypt column value in sql?

Caché

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 

 

wx fg's picture
Post by wx fg 10 days ago.

views

rating

Is there a function for convert string to hex?

Caché

hi

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

 

"abc"   convert to "616263"

 

 

thanks

wx fg's picture
Post by wx fg 8 days ago.

answers

views

rating

Use a global stored in variable.

Beginner, Caché

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... 

Russell Knight's picture
Post by Russell Knight 3 days ago.

views

rating

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

Beginner, Caché, Data Model, Key Value, Relational Tables, Globals, Performance

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:

Sergey Kamenev's picture
Post by Sergey Kamenev 13 days ago.

views

rating

How to Discover What's Inside the Global?

Beginner, Caché, Globals

Greetings,

Russell Knight's picture
Post by Russell Knight 3 days ago.

views

rating