Eduard,
Thank you for your answer, it was just what I was looking for.
But, what is ExtentFunc?
I did a search in the I/S Documentation and found no results.
I looked in %Library.Persistent but did not find it there.
I searched the Developer Community and got 1 hit, this post.
I even tried to Google it.
I did find the class %sqlcq.SAMPLES.cls9 from doing a ZW on the rs variable, but could not find the class.
So my friend, where did you get the method ExtentFunc from?
It would be really nice if how to navigate the DC would be documented somewhere.
Just trying to find my own posts is an hassle.
I am sorry to say this, but this is typical of most projects in a rush.
Get it out, get it out, get it out, We will worry about the planning and documentation later.
I have seen it time and time again.
Peter, please clarify your comments:
>>>>That for any reasonable sized database (ie less than <~10,000,000) rows on a modern server with adequate memory - it >>>>don't much matter!!! Cache will do the biz.
What do you mean Cache will do the biz?
>>>>>But give it a go
>>>>>As I said it don't much matter unless you are in serious terabyte country
Give it a go? Give what a go?
And what is serious terabyte country?
I am sorry, but I am just not following what you are saying.
Daniel, I tend to agree with you, the more I look at Parent/Child and compare to One/Many the more One/Many seems to be a better ch oice.
thanks.
Arto,
Thank you for the pointer.
I have seen the documentation before and read through it more than once.
But, I still cannot seem to wrap my mind around it what they are saying.
Is it just that InterSystem's documentation tries to be difficult, or is it just me?
Maybe they should put out a version of documentation for "Dummies"
I started this post and I appreciate everyone who contributed.
However, I see that the phrase "Extent Query" used a number of times.
I must admit that I really do not know its meaning.
Will someone help me understand the meanings and ramifications of "Extent Query"?
Perhaps I missed the post, but has any engineers weighed-in on the planning of Objects and SQL?
Was SQL part of the mix from the start?
One very important point is that SQL is easier to read and modify than Cache.
So maybe not in run time efficiency, but the advantage is to SQL for speed of changes.
One thought I had, I am not sure if it applies.
I assume that the Object processing code is more developed than the SQL processing code.
Assuming that holds, can we say that future SQL processing code has more to gain than future Object processing code?
If that is true, then going with SQL in the mix seems like the correct way to go.
Why do I have to join Telegram to see the data on Atelier?
I thought joining the Community was enough?
Sean,
I was the one who put the downvote in, and I explained myself in the reply.
Maybe you are not the person to ask, but you brought in the comment:
"You have a limited number of votes per day, and answer down-votes cost you a tiny bit of reputation on top of that; use them wisely."
I don't understand how using down-votes cost someone "a tiny bit of reputation"
Seems to me when a down-vote is used, it should enhance ones reputation as you are increasing the quality of a post.
Also, if the down-vote is used when:
"Use your downvotes whenever you encounter an egregiously sloppy, no-effort-expended post, or an answer that is clearly and perhaps dangerously incorrect."
If that is the criteria for downvotes, they will never be used, so why even have them?
This is nice documentation.
I am still confused between GROUPS and TAGS, they seem like the same thing.
Also, it would have been nice to have this information and much, much more at the beginning.
I did ask for documentation when DC was just starting but was told it should be intuitive, but it was never that to me.
(at least that was in my memory).
Anyway, the documentation is nice, but should be expanded and available through a shortcut, or is that a tag or group?
You say if I have any more questions, ask in this Group, how do I know what Group I am in? And how do I ask in a Group?
Thank you
I would also like to note that MERGE is extremely slow.
John, not to beat a dead horse, you say the facility already exists? Are you referring to the Vote Up/ Vote Down?
I thought that was for if one liked the post or not. I never associated it with whether one accepted the answer or not.
Sorry, but I see a difference here.
I have several posts that I like the answer, but do not accept it and the difinited answer.
But, maybe it does not matter.
I wonder who would decide what is an "accepted answer?" The original poster? Sometimes I get an answer to my post but it may be wrong, or incomplete, or a partial answer.
Ok, a member gets mentioned, but, what if the mentioned member does not wish to be mentioned?
There are shy folks out there who would rather not be mentioned.
Joe, I started going through your post and was confused by your first sentence.
Embedded SQL is a tool that allows us to SQL statements in Caché Object Script.
I assume you missed something between "to" and "SQL".
Embedded SQL is a tool that allows us to "what?" SQL statements in Caché Object Script.
Or, is it me who is missing something?
Thank you all for your suggestions.!
You asked for ideas, one thing I asked for a long time ago and still think it is needed is a Help function on how all of this works. It is not obvious to be sure.
I find it interesting, when I think of Dec 7, I don't think of the Developers Community, I think of the sneak attach on Pearl Harbor, but, maybe I am just getting old.
Alok, maybe I have not been in on the right projects the last 30 years. But I am mostly concerned in getting code to work efficiently. "Refactoring, parallelize computation, mutable data structures to synchronize?" You are talking over my head, and I think over the heads of most programmers in the trenches. I don't have time to try to understand what you are trying to say, I have real work to do. If you want to have a real impact, say things that really can help me.
Maybe you really have something valuable here, I don't know. But the way present, is a major put-off. As always, it is not what you say, but how you say it.
The definition of Declarative Programming I found is:
In computer science, declarative programming is a programming paradigm—a style of building the structure and elements of computer programs—that expresses the logic of a computation without describing its control flow.
Maybe my ignorance is showing here, but this seems like so much "pie in the sky", and I cannot relate it in a meaningful way to anything. Sorry folks, I guess this is just above my pay-grade.
What is "Markdown Editor?"
Very nice enhancements!
Evgeny, I know about passing a variable number of parameters (variable, not unlimited).
However, this is a post for NewBies and what you are talking about is advanced.
What does the star with the number mean in the lower left hand corner of each post?
On the whole a nice job. Three points however.
Be careful in saying the .CLS, .MAC code can be deleted. If they ever wish to change their code they will need the classes and possibly the .MAC code.
There continues to be a lot of confusion around writing .INT code as a main source. The VA does it all the time. The dangers of this should be pointed out.
The differences between .MAC (Macro) Routines and Macros should be explained.
Alexey Maslov wrote:
"If so, how do you answer the curious Newbie's question: why should I use Caché at all, as a few SQL implementations are available for free nowadays?"
I did not say SQL, I said "Caché SQL", with everything that implies.
All that has come before is great stuff, and extremely interesting. However, the Newbie can ignore it all, by using Caché SQL. Let Caché define the necessary Globals by using Classes/Methods and let Caché SQL retrieve your data. This is by far the better and more efficient way and is much more maintainable.
I went through a section of one of the courses.
It sure is an improvement over some of the previous courses in years past.
I can see a lot of work has gone into the courses and I commend those who did the work.
However, without an audio component, the courses quickly become tedious.
InterSystems is a world wide organization and leader in many respects, their online courses should reflect that.
Just my 2 cents. Don't kill the messenger.