OpenEdge Database - Products Enhancements - Progress Community

 OpenEdge Database

  • Falback code page in jdbc driver to handle databases with corruption

    • Under Review
    • 0 Comments
    Hello, regarding issue http://knowledgebase.progress.com/articles/Article/000052030 it would be highly desireable to have an option for the jdbc driver to be able to provide a fallback codepage so that if a character does not work it doesn't just...
  • SQL statistics

    This will be a bit vague... It is fairly well known that the SQL query engine uses a cost-based optimizer, and the standard first reply to anyone complaining of SQL query performance issues is "Have you updated statistics?" followed by the...
  • Separate counters for total & used buffers in -B/-B2

    Currently we have counters for total and used buffers in _BuffStatus and in promon R&D 1 7. But they only show aggregate totals for the primary and alternate buffer pools. Having separate counters for primary and alternate buffer pools would make...
  • A new costing algorithm in the SQL optimizer, to eliminate performance issues noted...

    • Under Review
    • 0 Comments
    Several months ago a customer I support was having varying results using the SQL Optimizer tool. We opened a support ticket with Progress support and they indicated this was not an issue with the tool per se, but a problem how SQL coordinates among join...
  • Ceate cluster management tool and transparent failover for resilient database with...

    • Under Review
    • 0 Comments
    Currently you can have replication and replication sets on databases but failover is stil something you'd probably prefer to do manually and automatic failover in case of a network split can cause split brain where multiple nodes can become master...
  • SQL Role: DataReader

    Currently it's very painful to grant read rights to all tables (now and in the future) for individual users. It's not possible and needs to be refreshed if new tables are added. It would be great to have a role DataReader which can be applied...
  • Allow character data type field to be initialized as GUID

    • Under Review
    • 0 Comments
    I know there are other discussions about adding a GUID data type or other such methods to accomplish this. However, several applications have already been using a GUID and storing it in a character field. This idea would allow for a character field...
  • Add indexes to _file and _index

    I often want to iterate over the application-specific records in _file or _index, e.g.: for each _file no-lock where _tbl-type = 't': // do stuff end. for each _index no-lock where not _index-name begins "_": // do other stuff end...
  • Certify OE 11 as FIPS 140-2 Compliant

    • Under Review
    • 0 Comments
    The US federal government requires FIPS 140-2 compliant solutions for encryption, transmission and storage of PII data. Lacking FIPS 140-2 compliance, we have to utilize 3rd party vendors top provide this functionality which is proving difficult/impossible...
  • Support .NET System.Transactions (Distributed Transactions)

    Right now the Enterprise database supports the JTA (Java Transaction API) X/Open Distributed Transactions. It would be a great feature if Distributed Transactions managed by .NET (like System.Transactions) were also supported. There is a big need for...