BG-BASE will be used initially to manage the living collections at Glasnevin and eventually to link plant collections of several other institutions throughout Ireland. BG-BASE will be used to track the thousands of new plant acquisitions that are planted each year. Existing records dating back several decades will also be entered into the system. The following gardens have upgraded to version 4 of BG-BASE from earlier versions. Edinburgh Scott Arboretum U.S. National Arboretum Many thanks to the other gardens that have ordered the upgrade.
Indexes are important in that they allow for very rapid retrieval of data.
In this issue we will discuss the use of Btree indexes. Btree indexes have been placed throughout BG-BASE so that queries involving certain fields will run very quickly. However, a little knowledge about where these indexes are stored and how they are used can save you a lot of time. Consider that in some cases there may be more than one way to generate the same report. If you have a choice between using a field with a Btree index versus using a field that has not been indexed, always use the indexed field.