1. Smart Joins : Try to Use Joins instead of nested while loop wherever possible. 2. Select Statement : Mention the field names in the select statement instead of fetching entire row, this will reduce data amount to transfer from database. e.g " Select Itemid from inventTable " 3. Display Methods : Make sure that generic display methods should be moved at table level and cached by using"Formdatasource.cacheAddmethod". 4. Local caching...