I decided to code up your benchmark myself, and I noticed something
else while doing it. You're fetching across two foreign objects in
this bit:
my $var = $cidade->estado_obj->pais_obj->nome;
To do that in one query using the RDBO manager, the require_objects
parameter should be:
requir
On 1/31/06, John Siracusa <[EMAIL PROTECTED]> wrote:
> CDBI will go back to the database to fetch those values. To change
> this, make all of the columns "essential" in your CDBI class:
>
> __PACKAGE__->columns(Essential => qw(id nome estado));
Yes, I think I forgot about this because there's
Oh, and I forgot one more RDBO speed tip. Throw a "prepare_cached =>
1" parameter in that Manager call. The Manager does not use
prepare_cached() by default. If you know you're going to be repeating
the same query many times, you should enable it, either per-call using
the prepare_cached param,
On 1/31/06, Nilson Santos Figueiredo Junior <[EMAIL PROTECTED]> wrote:
> Anyway, I re-run the tests with the changes you mentioned and,
> unfortunately, only CDBI performance improved. Now CDBI is slightly
> faster than RDBO, even with RDBO prefetching the objects and CDBI
> doing no prefetching. T
On 1/31/06, Nilson Santos Figueiredo Junior <[EMAIL PROTECTED]> wrote:
> I was trying to perform some fairly simple benchmarks comparing
> Rose::DB::Object, Class::DBI and an in-house solution and came up with
> some disappointing results from Rose::DB::Object.
>
> I'd like to know if there's somet
Hi,
I was trying to perform some fairly simple benchmarks comparing
Rose::DB::Object, Class::DBI and an in-house solution and came up with
some disappointing results from Rose::DB::Object.
I'd like to know if there's something I did wrong or that could be
done in a better way since RoseDB was onl
