Lodestar

In March 2008 EDF Energy asked us to help with performance tuning their production database. We were able to identify where in the code the poor performing queries were defined, and to develop more efficient versions of them using the Oracle plan tables (explain plan) to reduce overall cost, physical I/O and ultimately time taken to execute.

During autumn 2007 we were involved in ASP training for the Lodestar framework. Many aspects of the ASP framework were covered, with best practices, including stored queries, dictionaries, custom screens, tabs, dropdown actions, XML data, XSLT transforms, debugging and more!

End clients are keen to make use of the Lodestar applications, and see the flexibility the software provides. Custom ASP work should "fit in" with the framework, and we have successfully trained staff in the best way to go about developing for Lodestar.

Geode Software has been working for Oracle Utilities on a number of projects in the UK and now supplies a number of ASP developers to work on site. We worked to extend their web application to provide a detailed breakdown of all the costs involved in a gas supply contract. The web pages were written in Javascript ASP, linked to an Oracle (10g) database and the Lodestar framework. XML technologies were used heavily to manipulate the data for display.

LODESTAR's PricingExpert was customised in order to satisfy the requirements of a large energy company. Geode Software was invited to join it in order to extend their web application by providing additional screens and database functionality. The web pages were written in Javascript, linked to an Oracle (9i) database and the LODESTAR COM object framework.