in reply to Keeping hash table in memory

Will you be using the entire table each time? If not, consider storing the hash table in a temporary Sybase table.