Hi,

I'm trying to find the faster way to get the data from a class, and I find it very slow compared to traditional globals. So, I hope some of you can bring some light to me :-)

I have thousands of registers in a class, and to access it quickly I'm going with $o at the index. From there, I get the values using $listget(). Something like that:

Last answer 7 August 2018 Last comment 9 August 2018
0   0 6
381

views

0

rating

The newer dynamic SQL classes (%SQL.Statement and %StatementResult) perform better than %ResultSet, but I did not adopt them for some time because I had learned how to use %ResultSet. Finally, I made a cheat sheet, which I find useful when writing new code or rewriting old code. I thought other people might find it useful.

First, here is a somewhat more verbose adaptation of my cheat sheet:

Last comment 18 October 2017
+ 7   1 12
1293

views

+ 7

rating

I am inserting rows in a table. This table is appearing in all namespace as I did global mapping. 

So once I run insert command from a method, it insert the rows. When I run the same insert command from other namespace, it replace the existing data in table. 

Insert command is same in all namespace but the data I m inserting is different. 

 

Last answer 30 May 2017
0   0 3
0

comments

244

views

0

rating

Hello All,

I have a question / issue regarding the calling list.FindOref(<object from indexOpen call>)
Here is a simple way to reproduce the issue: 
2 classes: Utility.contacttypes and Utility.person
*************************

Class Utility.contacttypes Extends %Persistent
{
Property description As %Library.String(TRUNCATE = 1);
/// Index for property description
Index descriptionIndex On description [ Unique ];
}

*************************

Last answer 12 May 2017 Last comment 12 May 2017
+ 3   0 5
193

views

+ 3

rating

Hi!

We updated the DC a bit.

Member's answers

With this release, you can see the answers on the member's page too.

E.g. see the answers by Timothy Leavitt

Post updates don't move the post to top

So we can fix the tags, spelling and make other updates to the post and it would not be moved to top anymore. 

Last comment 2 December 2016
+ 2   0 1
113

views

+ 2

rating

NewBie's Corner Session 28 Various Methods to Traverse a Global

Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.

Judging from the number of responses to Session 27 Traversing A Global, developers are passionate about their methods. I am not here to judge the merit of the various methods.

Over the next few pages I will demonstrate a number of methods to Traverse a Global. If you don't already have a favorite they may help you pick one.

Last comment 4 October 2016
+ 2   0 8
455

views

+ 2

rating