Performance


z4OK, so yes, I did go a little mad the other weekend.  I’ve hankered for a roadster for many years and this little beauty presented itself and I took the leap. She’s garaged and only comes out at the weekends. However, that does not matter because she puts a smile on my face whilst she’s standing still as well as when I behind the wheel, feeding that 2.5 litre straight six and pushing her on through some sweeping bends.

Whilst modern she retains some glorious traditional lines, she looks fast when she’s standing still and when you open her up she’s as responsive as you like and she just flies.

OpenInsight 10 (OI10), for many of us has been a project that has seen the interface chance considerably. Whilst hugely functional, the old desktop interface was looking aged and not overly intuitive for new users. For experienced developers, the interface required a fair amount of clicking down through layers to achieve things or, at best you needed to know the shortcut keys. OI10 delivers a brand-new interface that is way more intuitive to use. There is no more clicking down through layers, so much more is right there in the interface or one click away and so, so much more has been exposed in the way of new controls, properties and more.

Whilst the O4W interface is still pretty new, it’s early releases were based around a two-column approach but OI10 opens up an array of new possibilities with multi-column design and drag and drop development.

I’ve played with the latter Alpha releases and I’m now getting more and more into the beta to convert my personally written contact manager that I use on a daily basis at RevSoft. I’m fast learning that OI10 all adds up to an easier to use interface with productivity gains to be found everywhere. I cannot believe how much code I can now remove from my forms by just setting one simple property in the Property Panel – that’s usually a case of inserting a single value (numeric or text), or making a picklist selection or toggling a property. OI10 is making our application developer easier than ever and introducing standards that will no doubt deliver better applications through consistency, stability and refined code.

So, the interface enhancements are nice, the O4W design options are more powerful but people still want better performance and on more than one occasion recently I’ve had discussions about indexing large files.

At conference last year, Bob spoke about the way that the conversion tools will optimise your tables. It is still work in progress but Revelation are mastering the dark art of balancing file-sizes with thresholds and a whole load of things that I really don’t understand. Bob’s also worked on caching things and using memory better and Andrew at Sprezzatura continues to explore ways to better configure the system for Linear Hash and find performance gains.

Some people don’t think that Revelation are taking performance seriously and listening to their customer base. I know for a fact that this is not the case. You only have to sit in the car with Mike on the way back from a User Group meeting to know that he personally takes customer needs and requested extremely seriously. On more than one occasion (in fact on many occasions) I’ve been driving him across the UK and he’s bashing away on his keyboard like it’s going to give up on him in the next ten minutes. We get to our destination and he shows me an example of something a client has suggested or requested and with a big smile on his face, he tells me that I can let my client know that it’s in the next release – subject to testing and quality control of course. It’s the little details like this that have kept me loyal to Revelation for the last 20 years, in a sales role that would normally have seen half a dozen sales people come and go.

Like the motorcar currently sitting in my garage just a few feet away from me, OpenInsight is maturing into one of IT’s classics which continues to deliver on the needs of the modern application developer. Not only does it look good and it’s wonderful to work with, hidden under the hood are a number of highly sought-after enhancements that are set to deliver some of those performance gains that the OpenInsight community have been asking for.

Just yesterday, after yet another call with a client looking at index performance on files with 500,000 plus rows, Andrew told me about some more of Bob’s enhancements to OpenInsight. Well, I just had to get some highlights from the man himself and, as a teaser, this is his reply:

“I have re-written index builds and updates. The high points are:

  • Rebuild uses in-memory hashtables and removes 64k workarounds which were in the legacy build.
  • Rebuild all for a table rebuilds all indexes in one pass, rather than individual passes
  • Update_Index is rewritten so that there is less contention on the root of the index. I made changes to SI.MFS as well.

…”

I don’t fully understand indexing but Bob tells me that the current system has to make numerous passes. One test that he undertook had to make six passes through a system with 500,000 rows. His greatly refined solution now makes just one pass through 500,000 rows, rather than having to work through 3,000,000 rows. He therefore has a very high level of confidence that the rebuild process work well and performance gains will be experienced across the board. I don’t have the figures, but he tells me that the 500,000 row rebuild was much faster and that’s good enough for me.

Other enhancements include a brand new update process that makes use of multiple sessions updating many tables at the same time. This has proven to be robust and fast during internal testing and we look forward to hearing the results obtained by our beta testers in the real world and running against real databases with hundreds of thousands or millions of rows.

I’m looking forward to getting out in the Z4 with Joanna, putting the convertible roof down and enjoying the wind in our hair. In the same way, I’m looking forward to working with the fresh looking OpenInsight toolset, modernising my applications and sharing this new gem of a toolset with the wider MultiValue community and the application development community in general.

We now have a fully integrated, highly functional toolset that is easy to use, powerful and fast. I can’t wait for the official OI10 release and to hear what Mike, Carl, Bob and the team have in the pipeline for OI11.

It’s going to be a great ride for the foreseeable future.

Advertisements

When is a bug not a bug…


… when Martyn is playing with the OpenInsight 10 Beta and his knowledge of the new system is lacking <lol>.

OI10Beta

As many of you will know, I have been working with the OpenInsight 10 alpha for sometime and I recently downloaded and begun playing with the official OI10 Beta which was released a week or so ago.

I’d reported a good number of issues to RevUS during the Alpha program and I’m pleased to see many of those issues resolved in the Beta and a mountain of other things now working and working really nicely.

OI10 is a massive change from the old 9.x versions.  It is so much easier to use and massively more developer friendly.  I’ve only really played in the forms designer (image above), popup designer and scripting tools but it is a brand new world compared to the old interface and tools.

For example, the Main Application Manager window lists your recently accessed entities, making access to those entities a day or two later super easy.  Once in the forms designer, you can now have multiple forms open and you can work on them all at the same time – although I’ve confused myself on numerous occasions and found that the tab bar gets a little full.  However, I absolutely love the ability to have a form open and then scripts and Quick Events open for that form, popups associated with that form, graphic files associated with that form and more – it’s just so intuitive and super, super easy to jump between entities.  No more closing things, drilling down to find new entities and opening them – it’s just a massive, massive time saver, let alone more organised.

Then you have the properties and events readily available at the side of the interface.  I usually have the Properties panel open because there are just so many properties that have been exposed to make life even easier for developers.

I used to write loads of lines of code to handle row shading, window positioning and the like, now it’s a value in the properties window.  This makes for exact positioning, the creation of some lovely looking windows, better graphics handling and much much more.

As I get more into OpenInsight 10, I find that it is the little details that are making all the difference.  For example, when compiling a form, I get an immediate notification of an issue in the output panel at the bottom of the window in red text.  So  much more is delivered right to the developer in the interface.

All of the usual tools are in the toolset, although just about everything has had a makeover or some level of enhancement.  The changes within the toolset are huge and massively beneficial.  The only downside is that there is going to be work for all of us moving existing OpenInsight applications to OpenInsight 10 but the benefits will be well, well worth the time and effort.

As for non-OpenInsight developers.  Well, Revelation are now delivering one of the few fully integrated application development suites for both super rich desktop and amazing web based applications.  We now have a very intuitive toolset that developers using other tools will be right at home with and which features form design tools, coding tools, debugging tools, reporting tools and much, much more for both desktop and web, right on one comprehensive toolset.

Another massive leap forward is O4W.  This ground breaking toolset, that I used some time ago (as a non developer) to build a proof of concept application and which was finished by the VAR and now used by the employees of some of the Internets biggest names (no need for me to say who), used to be based on a couple of columns and creating more complex interfaces was not overly easy.  With OpenInsight 10, all of that has been addressed and O4W10 (not it’s official name) has really matured into a brilliant piece of technology for those of us who don’t want to learn HTML5, Javascript and the like.

I might be more than a little biased, but I am totally and utterly blown away by what Revelation are now very close to delivering to the OpenInsight development community, the MultiValue development community for widely and business in general.

The beta program is currently open to all OpenInsight WORKS subscribers.  If you are reading this and you are not a WORKS member or you are new to Revelation Software, please contact your nearest Revelation office and we’ll be pleased to assist you in any way that we can.

I was told sometime ago that OpenInsight 10 was set to be a game changer.  I now know why that person said that to me and I can’t wait to learn more about converting my applications and building new systems and proof of concepts for clients and prospects.

Today is going to be a fun day


stock_login_window

So, I’m all caught up on my regular work, far too many people are on holiday and Revelation Software have just uploaded a nice present to my FTP site.  As I write this email, the brand new OI10 beta software (an advanced copy) is being downloaded to my machine and I’ve cleared my workload to spend the next few hours playing with it before RevUS opens.

What a great way to start a Monday morning :D.

OpenInsight 9.4 “Roll Up” Patch v3


OpenInsight 9.4

 Revelation Software have recently released a third roll up patch for OpenInsight making it much easier for developers and users to keep their systems up to date.

This patch includes all previous fixes for OpenInsight 9.4 and replaces the original  “Roll Up” Patch v1 released on March 3, 2016 and the second “Roll Up” Patch v2 released on March 8, 2016. The patches included are as follows:

  • BUTTONDOWN Event Handler Patch for OI 9.4
  • SQL Connector Patch for OI 9.4 v2
  • Buffer Overflow Error Patch for OI 9.4 v2
  • RevelationDotNet 9.4 “Roll Up” Patch
  • RTI_TASKMANAGER 9.4 Patch v2
  • O4W Validation Patch for OI 9.4
  • QBF Patch for OI 9.4
  • Arev32 Descending Sort Issue Patch for OI 9.4 v2
  • Single Sign On Patch for OI 9.4
  • CTODICT.MFS Patch for OI 9.4 v2
  • Arev32 Conversion Utility Patch for OI 9.4
  • Socket Functions Patch for OI 9.4
  • O4W Popup Patch for OI 9.4
  • Base64 Encode/Decode Patch for OI 9.4
  • PREVVAL Patch for OI 9.4
  • O4WGRAPHDATA Patch for OI 9.4
  • RTICDOMAIL Patch for OI 9.4
  • Banded Report Writer Patch for OI 9.4 v2
  • Engine Server Patch for OpenInsight 9.4
  • Listbox Patch for OpenInsight 9.4

Works members can download this patch from the Works Downloads section of our web site.

List User Locks Administration Tool for OI v9.4


OpenInsight 9.4

Revelation Software have released a new RDK via the WORKS section of http://www.revelation.com which contains an updated LIST_USER_LOCKS window, along with supporting LIST_USER_LOCKS and RTI_LH_INFO procedures.

This utility has been tested with OpenInsight 9.4 and above and the Universal Driver 4.7.2 and Universal Driver 5.0.0.5.

Execute the window LIST_USER_LOCKS. The window will display a list of locked records. Each line item will display computer name, volume, table and record keys. With the Universal Driver 5.0.0.5 the computer name will include the network logon and process ID so that you can determine exactly which session holds the lock on a terminal server.

Works members can download this utility from the Works Downloads section of the web site.
Read On….

New OI User Story


Plumbing Company Modernizes Services with Revelation Software
By Joyce Wells

New England Water Heater is a plumbing services company specializing in water heater repair and installation based in North Waltham, MA. The company provides a centralized service through a network of geographically dispersed plumbing companies in the surrounding region, including its own company, Home Services of New England (HSNE) Plumbing.

NEWH’s services include the sale, lease, installation, and repair of water heaters for non-commercial customers in the New England states, as well as other plumbing services, ranging from fixing leaking faucets to handling oil-to-gas conversions.

To support this work, the company provides a customer hotline in Massachusetts for more than 20,000 accounts. Revelation Software is the backbone of the overall IT system.

Goal
Today, businesses of all types are changing the way they operate. They are adopting hosted services rather than purchasing and maintaining software and hardware on-premises, and, as a result, employees also now frequently work remotely.

With the advances in IT services that have taken place over the past 5 years, NEWH saw an opportunity to move to a cloud-based system to support its employees and customers.  The goal was to improve its overall quality of service while also enabling office staff to access systems from home.

In addition, the company wanted to eliminate the overhead costs of office space, a local area network, and shared printers. Critical to the new set-up was the ability for its affiliated plumbing companies, as well as its own HSNE staff, to input information about service visits and billing into the system and access new assignments while on the road.

Process
In September 2015, NEWH and HSNE decided to eliminate their physical offices, where each employee was provided with a desk, telephone, shared printer, and a desktop computer connected to a local file server to perform their job, said David Harmacek of Harmacek Database Systems, who specializes in Revelation Software products. The process of publishing the company’s 28-year-old Advanced Revelation application to the cloud was handled by Harmacek, who has been a consultant to NEWH since 1994.

When the decision was made to migrate the system, NEWH had a typical Windows Server, internet connections, IP phones for customer support, and a range of website-oriented support interfaces, as well as a hybrid Arev (Advanced Revelation) 32 and OpenInsight 9.4 database system.

To modernize the operations, Harmacek put a plan in motion to switch to a hosted system and began implementing this new approach in February 2016.

The Arev32/OpenInsight system was migrated to a Parallels server. Since the telephones were already on an IP system, no adjustment needed to be made, but office documents and storage outside of the database needed to be moved to Microsoft Office 365 and OneDrive.

As a long-time Revelation Software customer, NEWH uses a system on Revelation’s OpenInsight 9.4 for business processes such as document management, phone calls, and customer support—everything but accounting.

Because the system is so critical to its business—handling processes such as document management, phone calls, and customer support—the NEWH migrated the system to the Parallels 2X RDP server, while also maintaining the physical system, to make sure that everything transitioned flawlessly.

Eventually, even though the company had not yet moved from its physical office space, it began using only the remote services, as if all the employees were working from home, said Harmacek. The dual on-premise and cloud approach lasted until late spring. By June 2016, the company no longer had physical offices, said Harmacek.

Biggest Challenge
“Working with a 28-year-old application, we found that there are many features that are no longer in use, while other capabilities are leveraged all the time and have been just working forever,” said Harmacek.

“The biggest challenge was eliminating the dependence on a local network for file storage and local printing, since the employees could no longer walk over to an office and hand someone a piece of paper, and they could no longer print anything,” he said.  This issue has been solved by using the feature in Parallels 2X that allows a local folder to be managed from the application. Reports and PDF files can be placed onto the remote desktop. Files, both PDFs and images, can be uploaded and integrated with the hosted database.  “Anything that needed to be done had to be accomplished by interacting with the system. I had to find all the places in the processes where this was needed and change the system to allow it to be done that way.”
Read On…

Listbox Patch


OI Eye SquareFollowing the release of the Windows 10 Creators Update by Microsoft recently, Revelation found that OpenInsight Listboxes were affected by the update.

A Listbox Patch for OpenInsight 9.4 has therefore been released to address this issue.   The Windows 10 Creators Update has caused Listboxes to no longer display properly in OpenInsight 9.4 and this new patch resolves this issue through the replacement of the existing OInsight.exe.

OpenInsight will show the version as 9.4.2 which can be viewed in the top left corner of the IDE.  OpenInsight Works Members can download the Listbox Patch for OpenInsight 9.4 from the Works Download section of our web site.  If you are an end user, please contact your application author to obtain your application upgrade accordingly.