The search/scan's 'select * from products' is killing my performance. It takes 17 secs for PostgreSQL to return the 38k sku's. What is my best option for dealing with this: 1. rewrite search to use WHERE clauses? if so, can someone point out where the 'search' sub is? 2. rewrite the results page to use [query]? 3. something else? Thanks, Christian http://www.yoda-speak.org