Encodex, developer of Microsoft .Net and SQL Server based applications, successfully evaluated and analyzed the .Net & SQL based Reporting System for a pharmaceutical research organization.
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.

/Oregon News Articles/ - PORTLAND, OR, October 30, 2006 - Encodex Technologies, developer of Microsoft .Net and SQL server based applications & Microsoft GOLD Partner; successfully analyzed the .Net & SQL server based reporting application for a leading pharmaceutical company. This evaluation led to the optimization of the existing database and generated accurate and faster reports.

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."

Press Release Contact Information:

Arun Joshi
Encodex Technologies India
Offshore Software Development
224 NW Broadway
portland, Oregon
USA 97006
Voice: (503) 267 6749
Website: Visit Our Website