That was a good idea, thanks. But the indexes seem to match on both machines (in fact, the table in question only has the one).
I'm not familiar with these concepts but have started to look into it. I see that in order to do 'explain', I must run it against the select statement in question. I know what select statement the DBI/DBD code executes (can use for comparison). But how can I see exactly what select statement Rose is doing? thanks for the help. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > Jonathan Vanasco > Sent: 20 April 2007 15:55 > To: Rose::DB::Object list > Subject: Re: [RDBO] Bizarre. New PC. Everything faster except > Rose which > is5X slower! > > > > > my guy feeling is that maybe you lost some indexes on db tables > during the migration > > i'd do a raw test in a sql client directly, bench query on each and > use 'explain' to see how the planner is attempting the call > > -------------------------------------------------------------- > ----------- > 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
