database optimizations, dropdown text