Search results

  1. jdpjamesp

    Ideas for caching a table?

    So will a temp-table cache persist across sessions if it's global shared? I'll have to have a play around with that today.
  2. jdpjamesp

    Ideas for caching a table?

    -B2 may be the path of least resistance. Staring me right in the face!!
  3. jdpjamesp

    Ideas for caching a table?

    OE 11.7.17 (or whatever the latest patch is). Redhat We have a table in the database that is the system control table. Pretty much every program has an include file in it to read this record. Sometimes this even happens multiple times due to nested includes. It's a mess. We are reading this...
  4. jdpjamesp

    Releasing memory

    Belt and braces I would be setting the memptr size to 0 on each iteration. The static class call is fine as is IMO.
  5. jdpjamesp

    Question After Imaging Files

    Auditing is designed for the job it sounds like you are trying to do. After imaging is not. :)
  6. jdpjamesp

    DB Viewer

    Looks like it shows the structure only. The instructions in the post above seem detailed enough. But this is a post from 2002, so who knows whether the app will work with modern Progress versions or not. I don't think the author is working in OpenEdge anymore either.
  7. jdpjamesp

    printer

    You're going to need to give a lot more context to this request before anyone has a hope of helping. :)
  8. jdpjamesp

    Add new objects online

    It should be painless but be aware the indexes will be added inactive and will need building/activating to be able to use them. I believe that as this is a new table, and therefore no active index to help with the activate, you will need to do this part offline, but I'm a bit sketchy on those...
  9. jdpjamesp

    Question Online Field/Table Description Changes

    Upgrade to OE 12.8 (when it's available later this year) as most structure changes will be allowed online.
  10. jdpjamesp

    PUG Challenge Americas 2023 Conference

    Mike's certified (as a DBA), so why not you as well! :)
  11. jdpjamesp

    OpenEdge enhancement request portal

    It's very frustrating when requests for less used products get overlooked, but in general, yes, the system works very well. A lot of features in 12.x releases have been community driven.
  12. jdpjamesp

    OpenEdge 12 - Silent Install

    When you say it doesn't work you're not actually saying how you know it doesn't work. The logfile suggests it was successful.
  13. jdpjamesp

    Question TCP vs. Shared Memory

    We have a case in point. This table has one record. Note the scale on the left.
  14. jdpjamesp

    Question TCP vs. Shared Memory

    There is a big "it depends" part of this answer. There are certain activities (I can't remember which!!) that are quicker via TCP.
  15. jdpjamesp

    OpenEdge Discord Server

    I managed to get this sorted. I've updated the first post with a permanently active link.
  16. jdpjamesp

    Question Need AI reorder or not? Please clarify.

    Your ai interval of 36000 basically means you will be switching on demand and not automatically. As a result if you lose the main DB server you'll still be losing all the work done since the last backup you got off that machine. IMO that interval should be a lot smaller although that does depend...
  17. jdpjamesp

    OpenEdge Discord Server

    The invite just expired. I will post another next week when I'm back on my home PC.
  18. jdpjamesp

    Change profile name

    Unfortunately it doesn't appear in the moderator queue. I believe it's something that Chris will need to sort out. As it happens I am also waiting for a username change!! :D
  19. jdpjamesp

    Linux script issue

    I found the slightly more interesting for you. The typo came about because I was trying to recover from the very weirdly formatted 6956 error. I got it working for that script but when I recreated the script to run for another database those weirdly formatted errors started appearing again. I...
Back
Top