All
Accepted answers
David Underhill · Dec 19, 2018 go to post

This is a good idea, hopefully everyone will do this but I did have a problem.

Perhaps I have done this incorrectly but I could not see a way to submit screenshots in the challenge and when you click the "lets review" button,  or whatever the actual text was,  it closes it as completed and there seems no way to submit a screenshot.  Also, the link to the challenge is for the same challenge number as it appears in and it takes you to the Global Masters front page.

Also, you don't seem able to review both as suggested, if you use the link again or search for the platform you haven't reviewed yet it will simply state you have already submitted a review.  I suspect this is because using the link you have to choose between Iris or Cache and so the offer is for one or the other but not both.

David Underhill · Nov 2, 2018 go to post

That's a good point and the code base example is useful but the question was specifically for leading zero's and the code base version might be overkill for this.

David Underhill · Nov 1, 2018 go to post

$P is how I do it as well and due to a quirk of $P you don't even have to set the variable first although if it is possible a value might already exist it is reccommended.

David Underhill · Dec 1, 2017 go to post

If you have an equivalent version of Cache installed with the manager source code available then take a look at briefsub^%GSIZE. 

You can copy this code and amend as you require, remember to include the sub routines it calls and you will have to set a few things up first.  I've done similar things in the past on older systems, the code can look daunting at first but isn't hard to understand enough to use.

On newer systems you would use the %Library.GlobalEdit class.

David Underhill · Apr 2, 2017 go to post

Another clarification, ppg's are not limited only by disk space, just like all other databases the maximum size of cachetemp can be set to stop infinite growth, this means the ppg's have the same limit.

Also remember, the more you use them the more cachetemp fills.

One last point is that other parts of cache such as odbc queries also use cachetemp for storage and so the whole of cachetemp is not always available.

As ever you have to plan usage appropriately based on the application and the database configuration.

David Underhill · Sep 30, 2016 go to post

Thanks for the update, I will study the tuning article in case it throws up anything new and also plan to do some benchmarking.

David Underhill · Sep 29, 2016 go to post

Thanks for bringing this up, I had forgotten to review this issue myself.  I would assume any performance loss could be negated using Cache's own buffers.

David Underhill · Sep 29, 2016 go to post

We have built our own schedulers in the main but for the odd Cache Task Manager task we have created we just export and import the subclass.