[Dbix-class] select from dual

Matt S Trout dbix-class at trout.me.uk
Wed Jul 12 20:02:19 CEST 2006


On 12 Jul 2006, at 18:53, Hartmaier Alexander wrote:

> Hi!
>
>
>
> If you grep through the dbic sources you can see that dbic uses raw  
> sql to do that, for example to the get last inserted id in Oracle:
>
>
>
> my $sql = "SELECT " . $seq . ".currval FROM DUAL";
>
> my ($id) = $self->_dbh->selectrow_array($sql);
>
>
>
> @mst: how much performance impact does the use of ‘’ instead of “”  
> have?

It doesn't. Don't be silly.

-- 
Matt S Trout, Technical Director, Shadowcat Systems Ltd.
Offering custom development, consultancy and support contracts for  
Catalyst,
DBIx::Class and BAST. Contact mst (at) shadowcatsystems.co.uk for  
details.
+ Help us build a better perl ORM: http://dbix- 
class.shadowcatsystems.co.uk/ +





More information about the Dbix-class mailing list