Wow, spend a day in meetings and you come out to find a huge thread about OPAC scalability. Have those of you worried about scaling for repeated hits looked into just stuffing this data into memory? Heck, a lot of us could probably serve our whole opacs out of memory these days, query indexes included. Fire up memcached and keep a hash of unique ids to circ counts and status (and whatever else) in there. Tend the cache with a slow query running at night and expire/replace data marginally more aggressively as any item's usage numbers go up. Three cheers for Moore's Law! (Or did somebody already say that?)