Re^3: RFC: How to name it? DBIx::Table::Denormalized, DBIx::Table::Dynamic, ...

in reply to Re^2: RFC: How to name it? DBIx::Table::Denormalized, DBIx::Table::Dynamic, ...
in thread RFC: How to name it? DBIx::Table::Denormalized, DBIx::Table::Dynamic, ...

I'm using alike setups in several places, without abysmal performance. I do wonder what we do differently. This is the classic approach, used by many. Did you perhaps forget the index on Property.file? That's kind of important to have.

Juerd # { site => 'juerd.nl', plp_site => 'plp.juerd.nl', do_not_use => 'spamtrap' }

Comment on Re^3: RFC: How to name it? DBIx::Table::Denormalized, DBIx::Table::Dynamic, ...

Replies are listed 'Best First'.
Re^4: RFC: How to name it? DBIx::Table::Denormalized, DBIx::Table::Dynamic, ... by Corion (Patriarch) on Sep 15, 2005 at 21:34 UTC
The problem is not so much with the table as with the queries I ran against the table, which needed many joins of the properties table with itself, and I found that these were really slow and also cumbersome to work with. On the other hand this was before I started using SQL::Abstract.	[reply]

In Section Seekers of Perl Wisdom