Article ID: 3019

Speeding Up Catalog Full Display in Genie

If full display of a Catalog record is very slow, it may be that the record is associated with many items and/or many loans (even if they are closed). This article describes how to improve the speed. This capability was provided in Genie 3.3, SP 1.

Follow these steps:

1. Using TextWorks (the Windows component), open the Loans textbase, and add a new Computed Number field named LoanIsReturned. Set the Computed Number Definition to fcount(LoanDateReturned). (If you changed the name of the LoanDateReturned field in the textbase, use the actual name instead.) After saving your changes, populate the new field by selecting Maintain> Rebuild a Field Index, selecting the new field, and checking the box labelled Recompute Field Value.
   
   
2. Next, use a text editor to add the new field to MyGenieFieldMaps.config. In the FieldMap associated with the Loans textbase, add the following element:
   
   <Field AppName="LoanIsReturned" UserName="LoanIsReturned" BoxLabel="Is Returned"/>
   
   
3. After editing the file and saving your changes, start Genie, reset the configuration by clicking the button on the Genie About screen, and test the Catalog full display with a record that had appeared very slow before.

That's all you have to do. Genie v3.3 SP 1 has added code that uses the LoanIsReturned field if it is present in the field map configuration file. (In a large Loans textbase, a search for ... AND LoanIsReturned = 0 is much faster than ... NOT LoanDateReturned = *, to limit the search to active loans.

Search Again or check the Support Forums