Re: [RDBO] Best way to do multiple calls to database

2007-03-29 Thread James Masters
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

Re: [RDBO] Best way to do multiple calls to database

2007-03-29 Thread James Masters
Sorry let me rewrite my q. again more accurately: Here is a real example. 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

Re: [RDBO] Best way to do multiple calls to database

2007-03-29 Thread John Siracusa
On 3/29/07 6:27 AM, James Masters wrote: So now $products is an array of all product information, just like %product was a hash of all product info. But how do I elegantly get that stock quantity info for a particular location out of the $products array? I need something like: foreach

Re: [RDBO] Best way to do multiple calls to database

2007-03-29 Thread Jonathan Vanasco
On Mar 29, 2007, at 3:23 AM, James Masters wrote: 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,

Re: [RDBO] Best way to do multiple calls to database

2007-03-29 Thread Perrin Harkins
On 3/29/07, James Masters [EMAIL PROTECTED] wrote: Mod Perl sounds very tempting but doesn't sound like it works too well with win32; Had enough trouble getting Rose working on win32 - spent days on it! I don't use Windows myself, but the Win32 packages that Randy Kobes supports for mod_perl

Re: [RDBO] Best way to do multiple calls to database

2007-03-29 Thread Jonathan Vanasco
On Mar 29, 2007, at 4:07 PM, James Masters wrote: So when you say startup, does this mean upon Apache startup or upon your script startup? I can see that if it's in Apache's memory before a script even runs, that would be hugely performance enhancing. apache startup. there's no point on