CELEPAR - Consulting of Corporate Systems in Java and Free Software

CLIENT
Companhia de Tecnologia da Informação e Comunicação do Paraná (Celepar)

 
AREA
Government

 
PROBLEM
A large number of enterprise systems developed in Java, combined with a high volume of access, led to performance degradation in critical systems, such as the Electronic Invoice System (NF-e) system.

 
SOLUTION
Visionnaire, through highly skilled professionals for the task of performance improvement and fine-tuning of corporate systems, has allowed systems to practically double their performance capacity. A focus was also given on improvements and fine-tuning for the databases. All the work was done in partnership with the professionals of the area of IT of Celepar.

 
RESULTS
In a short period of time, it was possible to practically double the capacity of the performance in critical corporate systems, the most important of which (the one that generated higher processing volume) was the Electronic Invoice System (NF-e) system. Through in-depth source code reviews and replanning of the application server's thread architecture, it was possible to achieve a nearly 100% performance gain over a record time of work, allowing the company to maintain the hardware and software platform for longer without the need to purchase new servers.

 
TECHNOLOGY
The technologies used were mostly free software, including Linux operating systems (RedHat, CentOS), JBoss application server, Apache Tomcat, MySQL and PostgreSQL databases, and the entire Java platform (JEE), including a number of Java APIs (JPA, for example). In addition, integrations and optimizations to Oracle databases were required.

 

   
Detailed problem:
With the large number of enterprise systems developed in Java, combined with the high volume of access to these systems, its performance began to decline, and clinical analysis was needed in the source code with a focus on system performance improvement.

 
By 2013, Celepar (Brazilian Portuguese for Information and Communication Technology Company of Paraná) was serving about 5,250 connection points in the state for more than 900 information systems. All 399 municipalities in the state of Paraná are served. Only the Electronic Invoice System (NF-e) processed millions of monthly invoices, which caused a heavy load on application servers and databases.

 
Detailed solution:
Visionnaire, through the work of its highly qualified professionals for this function, worked together with the technical team of Celepar to analyze the details of the source codes, directly in the points of greater processing, for optimization. In a few days it was able to optimize the code, the database and the JBoss servers, allowing the daily processing capacity (in the case of the NF-e system) to nearly double.

 
As an example of optimization, one of the points was the way the threads were being created in the application servers, which caused a heavy load on JBoss and connections to the databases. Through a replanning of the threads architecture, it was possible to gain fast and immediate performance in the systems.