Re: [RDBO] client out of memory with large table

2007-01-07 Thread Perrin Harkins
Tim Bunce wrote: > Just to be clear on this: The *DBI driver* does not do that. > > For MySQL the underlying db client library does that by default. > (I think that's also true for Postgres.) Oracle client libs default to > prefetching one extra row but DBD::Oracle tells it to prefetch about two >

Re: [RDBO] client out of memory with large table

2007-01-07 Thread Tim Bunce
On Sat, Jan 06, 2007 at 12:04:26AM -0500, Perrin Harkins wrote: > John Siracusa wrote: > > Finally, if you only want to turn this on for particular calls, remember > > that the db is an optional argument to all Manager methods. You can always > > make/get a $db, yank out the $dbh, set the attribut

Re: [RDBO] client out of memory with large table

2007-01-07 Thread Tim Bunce
On Fri, Jan 05, 2007 at 08:26:21PM -0500, Perrin Harkins wrote: > Neal Clark wrote: > > Ideally, I will be making iterators from SQL calls. The SQL will > > limit the number of rows as best as I can, but there will be times I > > need to iterate over every row. I read in one of the CPAN docs th

Re: [RDBO] build_query/require_objects question

2007-01-07 Thread Neal Clark
Wow John, my exact question is answered in that bit of the doc, I feel pretty silly for missing it. Thanks for the pointer. You should see me with my working program right now. I am dancing I am so happy. Also, I cannot tell you guys how much I love this module. Top 5 from CPAN easily. My l

Re: [RDBO] build_query/require_objects question

2007-01-07 Thread John Siracusa
On 1/7/07 3:08 PM, Neal Clark wrote: > I want to call get_objects on A::Manager with constraints for C, but I don't > know how to setup that relationship in class A, or if it is even possible. > i.e. I want to be able to say > > my $iterator = A::Manger->get_objects( > query => [ > data =>

[RDBO] build_query/require_objects question

2007-01-07 Thread Neal Clark
Hey everyone. Thanks again for help on that mysql_use_result and the iterator. In hindsight it wasn't really even a Rose::DB issue, so I really appreciate that you guys took time out to help me. I've come up with a good way to only use that client variable when I need it, and I am able to

Re: [RDBO] many to many relationship with attributes

2007-01-07 Thread John Siracusa
On 1/7/07 10:02 AM, Uwe Voelker wrote: > Then I have a question for John (or anybody else). I would like to use > an many to many relationship with attributes. This means my map class > (ProductColorMap in the examples) has an additional field (which is no > key column). How can I use this? > > Or

[RDBO] many to many relationship with attributes

2007-01-07 Thread Uwe Voelker
First, a happy new year to everybody. Then I have a question for John (or anybody else). I would like to use an many to many relationship with attributes. This means my map class (ProductColorMap in the examples) has an additional field (which is no key column). How can I use this? Or do I have t