On Wed, May 18, 2005 at 12:17:34AM +0900, rgilaard / few.vu.nl wrote: > create table as select ident,count(ident) as totnrchange from bookhistory group > by ident I don't know whay Ruby timeouts but I would suggest using a rule or a trigger to keep the aggregates updated. Regards Dalibor Sramek -- Dalibor Sramek http://www.insula.cz/dali \ In the eyes of cats / dalibor.sramek / insula.cz \ all things / >H blog http://www.transhumanismus.cz/blog.php \ belong to cats.