Microsoft .Net and SQL Server based applications and .Net & SQL based Reporting System Solutions
A leading pharmaceutical research and development organization collaborates with Encodex technologies to help them analyze their reporting systems and optimize their database to get faster and accurate results.
By: Arun Joshi – CEO & Founder
Arun Joshi, CEO Encodex Technologies says, "The core business of our client is development of new technologies and processes for the pharmaceutical industry. Their research scientists and engineers are involved in the scale-up and transfer of pharmaceutical processes into commercial manufacturing plants across the globe. All the information is entered from various software applications and stored in a Microsoft SQL database. The most critical part of the application was the report generation based on various parameters."
Our team of experts worked on-site to understand the application architecture, database design and search criteria.
Prashant Pawar, Director Engineering Encodex Technologies said "After the analysis and evaluation of the existing reporting application we set our plan of action. We optimized the database, changed the indexes and queries as per the reporting requirements. We provided more filter criteria to the user to narrow the search, which resulted in generating accurate search results thus reducing the size of the webpage. We fixed SQL Stored Procedures that processed the reports. We changed the processed so that only required fields were returned in a few database. This reduced the processing time and also the CPU usage."
About Encodex Technologies:
Encodex Technologies Inc. specializes in custom application software development, database solutions, custom web solutions and custom programming services. Our software development is versatile and is available in a variety of programming languages including: Visual Basic .NET (VB.NET) ASP, ASP .NET. Our talented programmers can develop custom software that utilizes MS SQL, Microsoft Access Databases and SharePoint. Contact us today to discuss about software project development or strategic partnership.
For more details visit http://www.encodexindia.com