dbix::profile(3) [debian man page]

Profile(3)						User Contributed Perl Documentation						Profile(3)

NAME

	 DBIx::Profile - DBI query profiler
	 Version 1.0

	 Copyright (c) 1999,2000 Jeff Lathan, Kerry Clendinning.
	 All rights reserved.

	 This program is free software; you can redistribute it and/or modify it
	 under the same terms as Perl itself.

SYNOPSIS

	 use DBIx::Profile; or "perl -MDBIx::Profile <program>"
	 use DBI;
	 $dbh->printProfile();

DESCRIPTION

	 DBIx::Profile is a quick and easy, and mostly transparent, profiler
	 for scripts using DBI.  It collects information on the query
	 level, and keeps track of first, failed, normal, and total amounts
	 (count, wall clock, CPU time) for each function on the query.

	 NOTE: DBIx::Profile use Time::HiRes to clock the wall time and
	 the old standby times() to clock the CPU time.  The CPU time is
	 pretty coarse.

	 DBIx::Profile can also trace the execution of queries.  It will print
	 a timestamp and the query that was called.  This is optional, and
	 occurs only when the environment variable DBIXPROFILETRACE is set
	 to 1. (ex: (bash) export DBIXPROFILETRACE=1).

	 Not all DBI methods are profiled at this time.
	 Except for replacing the existing "use" and "connect" statements,
	 DBIx::Profile allows DBI functions to be called as usual on handles.

	 Prints information to STDERR, prefaced with the pid.

RECIPE

	 1) Add "use DBIx::Profile" or execute "perl -MDBIx::Profile <program>"
	 2) Optional: add $dbh->printProfile (will execute during
	    disconnect otherwise)
	 3) Run code
	 4) Data output will happen at printProfile or $dbh->disconnect;

METHODS

	 printProfile
	    $dbh->printProfile();

	    Will print out the data collected.
	    If this is not called before disconnect, disconnect will call
	    printProfile.

	 setLogFile
	    $dbh->setLogFile("ProfileOutput.txt");

	    Will save all output to the file.

AUTHORS

	 Jeff Lathan, lathan@pobox.com
	 Kerry Clendinning, kerry@deja.com

	 Aaron Lee, aaron@pointx.org
	 Michael G Schwern, schwern@pobox.com

SEE ALSO

	 L<perl(1)>, L<DBI>

perl v5.8.0							    2001-12-17								Profile(3)

DBIx::Simple::Comparison(3)				User Contributed Perl Documentation			       DBIx::Simple::Comparison(3)

NAME

       DBIx::Simple::Comparison - DBIx::Simple in DBI jargon

DESCRIPTION

       This is just a simple and inaccurate overview of what DBI things the DBIx::Simple things represent, or the other way around.

       This document can be useful to find the foo equivalent of bar.

       "?" means that DBI doesn't have an equivalent or that I couldn't find one.

       "=" means that DBIx::Simple provides a direct wrapper to the DBI function.

       "~" means that DBIx::Simple's method does more or less the same, but usually in a more high level way: context sensitive, combining things,
       automatically taking care of something.

       Note that DBIx::Simple is a wrapper around DBI. It is not "better" than DBI. In fact, DBIx::Simple cannot work without DBI.

       Using DBI directly is always faster than using DBIx::Simple's equivalents. (For the computer, that is. For you, DBIx::Simple is supposed to
       be faster.)

   Classes, common names
	use DBI       ~  use DBIx::Simple

	$DBI::errstr  =  DBIx::Simple->error

	DBI::db       ~  DBIx::Simple
	$dbh	      ~  $db
	$dbh->errstr  =  $db->error

	connect       ~  connect
	connect       ~  new

	DBI::st       ~  DBIx::Simple::Result
	<undef>       ~  DBIx::Simple::Dummy
	$sth	      ~  $result

   Queries
       DBI

	my $sth = $dbh->prepare_cached($query);
	$sth->execute(@values);

       ~ DBIx::Simple

	my $result = $db->query($query, $values);

   Results
	DBI			     DBIx::Simple

	bind_columns		  ~  bind

	fetchrow_arrayref/fetch   =  fetch
	fetchrow_array		  ~  list
	*1			  ~  flat
	[@{fetchrow_arrayref}]	  =  array
	fetchall_arrayref	  ~  arrays
	fetchrow_hashref() *2*3   =  hash
	fetchall_arrayref({}) *4  ~  hashes

	fetchall_hashref *2	  =  map_hashes
	?			  ?  map_arrays
	fetchall_hashref(1) *2	  =  map

	$sth->{NAME_lc/NAME}	  =  $result->columns

       *1 There's no fetch variant, but you can do "{ @{ $dbh->selectcol_arrayref('SELECT ...', { Slice => [] }) } }".

       *2 To receive the keys (column names) lowercased, use "$db->{FetchHashKeyName} = 'NAME_lc'". DBIx::Simple lower cases them by default.

       *3 Or supply an argument, 'NAME_lc'.

       *4 No, arrayref isn't a typo. When supplied an empty hash reference, DBI's fetchall_arrayref actually returns hashrefs. This DBI method
       does not support lower casing of keys, DBIx::Simple does.

   Direct access
	DBI		    DBIx::Simple

	$dbh		 =  $db->dbh
	$sth->{$foo}	 =  $result->attr($foo)

	func		 =  func

	begin_work	 =  begin_work
	commit		 =  commit
	rollback	 =  rollback
	last_insert_id	 =  last_insert_id
	rows		 =  rows

	disconnect	 ~  disconnect
	finish		 ~  finish

   DBIx::Simple specific (?)
	keep_statements
	lc_columns
	iquery (via SQL::Interp)
	select, insert, update, delete (via SQL::Abstract)
	abstract (via SQL::Abstract)
	flat
	hashes
	map_arrays
	map

AUTHOR

       Juerd Waalboer <juerd@cpan.org> <http://juerd.nl/>

SEE ALSO

       DBI, DBIx::Simple

perl v5.16.3							    2010-12-03					       DBIx::Simple::Comparison(3)