Thanks; I've now got both of these debugging methods to work and written a
test program that only does the DBI/DBD call and then the equivalent Rose
call.
They both appear to do exactly the same thing although Rose explicitly lists
the fields whereas my own DBD call just uses * instead. Tried this from the
MySQL command line anyway and in both cases, it takes <= 0.03 secs.
The trouble is that neither of them give precise timings so I cannot see if
the durations vary when I run these commands via PERL; just the start time
in seconds. Is there a way to log Mysql when run from PERL to give the time
taken which is what you get by default from the command line (i.e. Query OK,
847 rows affected (0.03 sec)"?
Here is the output:
070421 16:06:51 19 Connect [EMAIL PROTECTED] on mg
19 Query set autocommit=1
19 Query show columns from products
19 Query select * from products
070421 16:06:54 20 Connect [EMAIL PROTECTED] on mg
20 Query set autocommit=1
20 Query SELECT
Category,
Competitor,
CompetitorDate,
CompetitorPrice,
CompetitorPriceWithShip,
DefaultPriceLocation,
Description,
DimensionsImperial,
DimensionsMetric,
ExportClassification,
ExportOriginCountry,
ExportRestriction,
IncludeShipCost,
MGPrice,
MarkupOverride,
MaxParcelQty,
PriceCategory,
PriceType,
Status,
SubCategory,
UID,
XmasUnavail,
prodcode
FROM
products
20 Quit
19 Quit
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of John
> Siracusa
> Sent: 20 April 2007 19:20
> To: Rose::DB::Object list
> Subject: Re: [RDBO] Bizarre. New PC. Everything faster except Rose
> whichis5X slower!
>
>
> On 4/20/07, James Masters <[EMAIL PROTECTED]> wrote:
> > how can I see exactly what select statement Rose is doing?
>
> Either turn on DBI->trace(...) or set these variables:
>
> $Rose::DB::Object::Debug = 1;
> $Rose::DB::Object::Manager::Debug = 1;
>
> The DBI approach is probably better, but also noisier.
>
> -John
>
> --------------------------------------------------------------
> -----------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Rose-db-object mailing list
> Rose-db-object@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/rose-db-object
>
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
