DBIx::Recordset is able to write a logfile so you can see what's happening inside. There are two public variables and the !Debug parameter used for this purpose:

	$DBIx::Recordset::Debug or !Debug
	Debuglevel 0 = off 1 = log only errors 2 = show connect, disconnect and SQL Statements 3 = some more infos 4 = much infos $DBIx::Recordset::Debug sets the default debug level for new objects, !Debug can be used to set the debuglevel on a per object basis.
	DBIx::Recordset::LOG
	The filehandle used for logging. The default is STDOUT, unless you are running under HTML::Embperl, in which case the default is the Embperl logfile.

 Example:

    # open the log file
    open LOG, ">test.log" or die "Cannot open test.log" ; 

    # assign filehandle
    *DBIx::Recordset::LOG = \*LOG ; 
    
    # set debugging level
    $DBIx::Recordset::Debug = 2 ; 

    # now you can create a new DBIx::Recordset object