Skip to Content
author's profile photo Former Member
Former Member

Migrating from PB 7 to PB 12.5.2

Hello,

I am converting an application from PB 7 to PB 12.5.2 and this application uses DPBSERV (3-tier using proxys/TCP-IP)

The question is: what is the best way to convert the application server?

In our tests we use webservices but performance is very poor, about 20 times slower.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 26, 2013 at 01:33 PM

    From the "strange but true" department...

    Eight or nine years ago I needed to interface PowerBuilder with a very old system (old as in written by a company called IV-Phase Systems in the early 1970s) which runs on UNIX systems. In the end I decided to reverse engineer the DPB service and network interface and wrote a TCP/IP service for SCO UnixWare in C++ that "looked" like a DPB Server. The service worked well and as far as I know, the hospital I wrote it for still has a PowerBuilder 7.0 DPB clients talking to their UNIX systems via this service.

    I'm sure that if SAP was to dust off DPB and put it into PowerBuilder 15 I could knock on their door and sell them a considerable amount of time upgrading and enhancing their systems. That really was a fun project. 😊

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 26, 2013 at 03:47 AM

    Hi Fernando;

    Dale is correct ... EAS is basically at its EOL. IIs is not a real application server .. its a Web server thinks is an application server ("wannabe") and can not compete with the likes of the mature J2EE application servers in either performance or feature set.

    The only exception to IIS's application server handicaps is when you add something like the Appeon Server into the mix that is really an IIs "Helper" to significantly boost IIS's lack of full application server features.

    MS is of course counting on the fact that you will use IIs and once hooked - will want to seel you on a "farm" of servers, OS licenses, etc to compensate for IIS's les than stellar single machine performance.

    IMHO ... SAP should bring back DPB to replace EAServer and kick some Application Server "ass" - both in the performance and price areas!

    Regards ... Chris

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Everybody, I just wanted to shed some light on Chris' post regarding server choice for Appeon. Appeon can run on virtually any server so we get this question all the time: what server should I choose?

      We have thousands of customers deployed with Appeon and we have done extensive testing in our labs as well using simulated load testing tools. I will share with you some key points:

      1. About half of all Appeon customers are using EAServer as their application server and it is working reliably for them. It is true that EAServer is in maintenance mode and no major enhancements being made to it, but it is still a supported application server with thousands of companies using it . One of the key benefits is that EAServer can natively host PB NVOs and Appeon is most tightly integrated with EAServer, making the installation and configuration process a breeze.

      2. The server response of IIS to execute Appeon DataWindow retrieves is about 20% faster than several Java servers we tested, including EAServer. This holds true for most queries except for ridiculous size queries, for example retrieve several hundred thousand rows of data into a DataWindow. Tests were performed over a LAN so it is a measure of the server response time only not network transfer speed.

      3. Out of several commercial Java servers we tested we found they recover from very sever application errors better than IIS. We have yet to have a recent version of any Java server, including EAServer 5.5 or 6.3, prove to be unstable. We have, however, had a few customers that had some stability issues with IIS 6. IIS 7.5 seems to be much better.

      4. Out of the Java servers, if price is no object and you will be deploying to tens of thousands of customers we recommend WebSphere or WebLogic. We have a customer who has deployed Appeon successfully to 30,000 users with WebSphere. We also have a number of customers that have deployed mission-critical apps that must be 24x7 available, again they choose WebLogic.

      Are you more confused now? The point is this, there is no one size fits all recommendation. Depending on the # of users, architecture of your PowerBuilder code, performance requirements, experience of your staff with Java or .NET, budget, etc. there is a server out there for you. So it's about finding the right tool for your particular job, and that's why Appeon has invested to make our product compatible and certified on so many different servers, including open-source options.

      Hope this is helpful for you guys!

  • author's profile photo Former Member
    Former Member
    Posted on May 24, 2013 at 08:13 PM

    Over the years I've converted a number of applications from DPB PowerBuilder 7.0.x to later versions using EA-Server with (virtually) no performance hit. Unfortunately EA-Server looks like it's at the end of its road, that and it is a bit fiddly (to say the least) when converting objects from DPB. If you want to go this route hopefully you have a good foundation in your DPB code so that you only have to make a few changes when you step into EA-Server.

    The above said, I still have two clients running DPB applicaitons and they're in no hurry to upgrade. Oddly enough they are both holding out hope that SAP will dust off the old DPB code and put it into PowerBuilder 15. While I'm not holding my breath, I'd love to see that done as well. 😊

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 25, 2013 at 03:08 AM

    http://www.topwizprogramming.com/freecode_winsock.html may help with inter-machine communications. But web services may be the way forward, as the application server plugin seems moribund as well.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.