Thanks for your very helpful reply, Jonathan. It answered my general question but I'm left with a couple of more specific ones.
Pl. see in line. > I do that with ~20 tables that hold data I consider 'constants'. If > this data is unchanging, there's no need to continually hit the db. > ( note, i do this in a persistent environment , and i use that data > nonstop. i think its easier putting config/constant data in a db > than an xml / hash ) Yes, that's it. It's for data that is constant, for the purposes of the script in question. But I am v. interested to know how you do this. Do you do a Rose call and then iterate through all the objects creating a hash? I've now written something to do this. > > 3. Get Rose to do 1 more elegantly in a way that I haven't > yet found: > > $oldsuppliers = $suppliers->(query => [obsolete => {eq => > 'Y'}]) or > > something. > > Q1: Is 3 or something like possible? > Do you mean using the cached data, or just in general -- No I didn't mean the cached data (at least I don't think I mean that). Here is a real example that leaves me baffled. Having already loaded all products with Rose, I now want to see how many of a product are at a particular location which comes from a one_to_many relationship with another table locations. With my old hash method of doing this it would be trivially simple : $product{locations}{$location}{stockqty}. I'm thought it would be trivially simple with Rose too but it doesn't seem to be. $products = MG::Product::Manager->get_products(require_objects => ['locations']; So now $products is an array of all product information, just like %product was a hash of all product info. But how do I get that stock quantity info for a particular location out of the $products array? $products->locations->$location->stockqty won't work of course $products->locations(locationcode => $location)->stockqty won't work either. Is there a solution? Or do I just have to do another call to the DB? ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object