Benjamin Spead

Primary tabs

User posts
Articles (7) Questions (10) Announcements All (22)

Every developer has made the mistake of accidentally leaving temporary debug code in place when they meant to remove it after debugging is complete.  The great thing about writing in ObjectScript is that there is a way to make temporary code be truly temporary and automatically self-destruct!   This can also be done in such a way that the code has no change of making it into your source control stream, which can be helpful as well.

Continue Reading
Benjamin Spead's picture
Benjamin Spead 30 September 2019
Last comment 10 days ago
+ 3   0 2
1

comments
134

views

+ 3

rating

There are three things most important to any SQL performance conversation:  Indices, TuneTable, and Show Plan.  The attached PDFs includes historical presentations on these topics that cover the basics of these 3 things in one place.  Our documentation provides more detail on these and other SQL Performance topics in the links below.  The eLearning options reinforces several of these topics.  In addition, there are several Developer Community articles which touch on SQL performance, and those relevant links are also listed.

There is a fair amount of repetition in the information listed below.  The most important aspects of SQL performance to consider are:

  1. The types of indices available
  2. Using one index type over another
  3. The information TuneTable gathers for a table and what it means to the Optimizer
  4. How to read a Show Plan to better understand if a query is good or bad
Continue Reading
Benjamin Spead's picture
Benjamin Spead 11 January 2019
Last comment 18 January 2019
+ 8   3 2
1

comments
407

views

+ 8

rating

I need to write a script to answer a couple of fairly simple questions:

1) What is the current routine DB (name and location) for this namespace?

2) What is the current data DB (name and location) for this namespace?

3) Is global ^ABC mapped to a different location than the default data DB?

Can anyone point me to some system APIs that would allow me to answer these questions?

Thanks!

Ben

Continue Reading
Benjamin Spead's picture
Benjamin Spead 14 November 2018
Last answer 14 November 2018
0   0 3
2

answers
0

comments

116

views

0

rating

1) I have an oref pointing to an object on disk

2) I save the object which causes an UPDATE / AFTER Trigger to fire, and updates a value in an embedded object property

3)  I would like to see that new embedded property value in my in-memory object (for unit testing)

Is there a way to do this via a method call?  Or do I need to close the object and re-open it to see the updated value?

Thanks!

Ben

Continue Reading
Benjamin Spead's picture
Benjamin Spead 19 June 2018
Last answer 19 June 2018
0   0 1
1

answers
0

comments

129

views

0

rating

I have a serial object:

Class EmbedObj Extends %SerialObject

which is stored as a  property of another object

Class ContainerObj Extends %Persistent

Property InnerObj As EmbedObj;

Property Foobar As %String;

Question:

From within the context of an instance of EmbedObj, how can I navigate to the containing instance of "ContainterObj" and find that value of its Foobar property?

Continue Reading
Benjamin Spead's picture
Benjamin Spead 12 June 2018
Last answer 13 June 2018 Last comment 17 June 2018
0   0 4
3

answers
6

comments
312

views

0

rating

NOTE:  This content was originally presented at the InterSystems Global Summit in 2014, however related topics often come up on the Developer Community so I have decided to turn this into an article for easier reference and discussion.  However, much of the content was pulled directly from the presentation slides so the article format resembles that of a PPT deck more than paragraphs.

Continue Reading
Benjamin Spead's picture
Benjamin Spead 25 April 2018
+ 5   2 5
0

comments

495

views

+ 5

rating