K
Keith Sudbury
Guest
Performance, scaling and fault tolerance are really database related issues for OE applications. For all applications really. Code can be spread around and easily scaled out... the issue is always with the database. The databases are the center of the universe and everything is limited by how fast data moves in and out. If not... you have some coding/design issues to deal with. With the current OE app I am supporting we can spin up appserver and UI hosts on demand. Everything is load balanced and spread across multiple datacenters. No real scaling, performance or fault tolerance issues there. Scaling up/out a DB server is obviously much more complicated as is the current failover process. Especially when compared to Oracle or SQL Server. I have faith that PSC will solve some of these issues in the near term and more as time goes on. Right now we aren't near the current hardware limits and newer/faster servers always show up every year. I made the remark about leaving to suggest that you have productive choices to make... give up on OE and move on, continue to use what you think is a dying platform or focus on the real issues that OE faces. Wishing for fringe improvements that have little real world business value is just going to frustrate you. There is nothing inherit in functional languages that make them better than ABL (or T-SQL, PL-SQL, Python, C#, etc.) for real wold applications. Bad design is bad design. I have seen plenty of examples of good and horrible applications written in all of those languages against various databases. I can't think of a single example where the root cause of any performance problem was related to the ability of the programming language to scale/perform. Everything has been design related, poor queries/indexes, hardware/network related or database tuning related. Many of us support/have supported OE based systems with terabytes of data and thousands of concurrent users. OE indeed has issues but lets not pretend that it isn't suitable for a large percentage of business applications. You also have to understand that PSC is going to implement new features based on customer demand and their perceptions of the value of those features. Whether you see actors as esoteric or not.. the business world in general does.
Continue reading...
Continue reading...