[CDBI] How well does Class::DBI scale?

Perrin Harkins perrin at elem.com
Mon Dec 19 05:33:10 GMT 2005


On Mon, 2005-12-19 at 10:05 +1100, Rick Welykochy wrote:
> Not really. First off, the SQL logging is vast, i.e. thousands of
> SQLs in some instances. I have yet to delve deep down into the quagmire
> to see what is happeneing exactly, but I fear the %Live_Objects mechanism
> is flakey.

It's not a cache.  It is not intended to save you any database queries.
Just turn it off if it bothers you.  I do.

> Let's say we have one hundred rows the refer to foreign key 86
> in the units table. The units table has a (id,name) pair. I will
> see one hundred SQL requests for (id=86,name) from the database!
> I find this strange if the corresponding Unit object has already
> been _flesh()'d out once.
> 
> Note that in the case of this Unit stuff, the only Essential
> column is the primary key. Would this explain the behaviour?

Yes, incorrect keys will cause tons of problems.  Fix your primary key
so that the database and your Class::DBI classes agree on it.

- Perrin





More information about the ClassDBI mailing list