Yes, the Boston PUG is late September & Early October, Europe is in early November. As James says, time flies, it will be on us before you know it.
FWIW, that all _sounds_ wonderful but so has every fad of the last 75 years of computing. Some concrete and digestable examples sure would be nice.
Forgive me if I am just an old fossil but I am having difficulty understanding the attraction of migrating a schema to neo4j. This approach seems like it might be helpful for OLAP applications or for adding on such functionality but I don't see that there is anything there that would be very...
FWIW...
I think the difference here is that you are actively investigating something that you already know is a problem.
I am a bit more focused on diagnosing a situation that I didn't know about ahead of time.
Minor detail: you only get the top of the stack with type "1". You need type "2"...
Regarding the client statement cache and "3" vs "1"...
The problem that I have with using "3" to try to get to the bottom of a problem is that a lot of problematic code starts off with something like reading a control record. And then it dives into the more complex and problematic stuff. Worse...
ProTop has such a watchdog.
We do not, however, do anything specific about multiple database situations. You are probably an exception but in our experience that kind of thing will occur in the "main" database first and foremost and it when we disconnect that session the others will follow. If...
Probably because "the" FOR EACH is awfully optimistic.
Sure, you could do stuff with dynamic queries but that's going to be a lot more complex and may introduce performance concerns.
Sure.
And depending on why and how you are doing this one or the other is more useful.
I get it, you don't like "wasting" bunches of updates and the associated latches etc that are never going to actually be read. I don't like that either.
However - many people do NOT have thousands of...
"Client networking" is only needed if your connections from PASOE to a database are going to be using the -S connection parameter. If they are shared memory connections you do not need client networking.
George said:
That depends entirely on your circumstances.
Sure, if you have hundreds (or thousands) of remote connections enabling "cachingType = 1" for all of them could be rather painful. ("2" would be even worse...)
But if they are all shared memory connections the penalty is pretty...
Lest anyone think that I am on vacation...
OpenEdge 11.1 is ancient, obsolete, and unsupported. You should upgrade.
All of OE11 is now ancient & obsolete but 11.7 is a much, much better place to be than 11.1.
Since you speak of run time arguments you apparently have source code and a compiler...
It can seem like it is almost all that they talk about these days... not that that is different from anyone else!
Can I summarize it? No, I'm much too grouchy. But they sure do talk about it a lot.
Come to a PUG and learn more!
Granted there isn't much of an argument to be had.
Personally, I like to try to get it close to a useful value primarily because I have a utility that does random sampling of tables by randomly generating RECIDs and I can avoid a lot of wasted effort by having a RPB that is a better fit.
But...
A table called "wrkfile" strikes me as something that might be worth discussing. Is this a table that contains temporary data? Do you write a bunch of things there, do something, and then eventually delete all of that data? If you do, then that would be something that could benefit quite a lot...
I wouldn't go so far as to say that mean size is "meaningless".
Sure, it is not perfect and there are certainly cases where it doesn't work as well as something else.
It is, however, readily available and it works reasonably well in many cases.
That's worth quite a lot.
I haven’t tried this but… you could try restoring and then running proutil truncate area on the audit area. That’s not quite what you are asking for but it might get you the same result.
As Rob says though - you should not be keeping large amounts of audit data in your production instance in...
At a very high level...
You cannot migrate to PASOE *after* migrating the database. Classic appserver is NOT available on oe12, thus you must migrate your appservers before or during the migration.
You DO NOT want to be doing that for the first time the same weekend that you migrate the...
The database upgrade procedure itself is simple and straightforward. All that you need to do is to run "proutil dbname -C conv1112".
Of course, as you note, you need test everything and have backups and and a rollback plan. And a whole lot of that is very specific to your particular...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.