[Dbix-class] Q: Differing column names in DBIC and SQL

Bernhard Graf dbic3 at augensalat.de
Tue Oct 21 12:47:12 BST 2008


Peter Rabbitson wrote:

> > - AFAIR their usage slows down db access once more.
>
> Please bring some evidence for your last claim. If this turns out to
> be true, someone will be happy to investigate this matter further.
> However for now I and people whose opinion I value, consider this as
> shameless FUD spread.

AFAIR means that I don't have a source at hand, though it is quite 
obvious, that regex'ing each name in an SQL handle to insert 
quote_char-s and name_sep-s will slow down the process somehow.

Or the other way round: Prefixing fields with underscore on deployment 
means faster queries than applying quote_char-s and name_sep-s in each 
query.
-- 
Bernhard Graf



More information about the DBIx-Class mailing list