Sorry to give what must appear to be a running commentary (it's been over quite a long period for me) but I have now fixed this. Using the mysql query log, I noticed that logon via rose was coming in as [EMAIL PROTECTED] whereas logon via straight DBI/DBD was [EMAIL PROTECTED]
I don't know why that is but adding the following to the mysql server INI file made the delay go away: skip-name-resolve Presumably, mysql isn't getting a hostname from the rose logon and attempts to do a reverse lookup on the ip address. When this fails, it carries on anyway. I thought that reverse lookup timeouts were much longer than 2 secs but apparently not in my case. Ah, well. Maybe the solution to my nightmare will turn out to be useful for someone else in the future. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Behalf Of James > Masters > Sent: 21 April 2007 23:21 > To: Rose::DB::Object list (E-mail) > Subject: Re: [RDBO] Bizarre. New PC. Everything faster except > Rosewhichis5Xslower! > > > After tinkering for some hours, I've finally made some > progress using Dprof. > I now have a test program on my new fast server that does > only the single > ultra-simple Rose Manager call: get_products. If I run > dprofpp -r to show > actual time, then the following is revealed: > > C:\Information\mgroot\cgi-bin>dprofpp -r > ...... > Total Elapsed Time = 2.923462 Seconds > Real Time = 2.923462 Seconds > Exclusive Times > %Time ExclSec CumulS #Calls sec/call Csec/c Name > 77.4 2.265 2.265 1 2.2650 2.2650 DBD::mysql::db::_login > 2.57 0.075 0.149 1922 0.0000 0.0001 Rose::Object::init > 1.61 0.047 0.047 18656 0.0000 0.0000 > Rose::DB::Object::MakeMethods::Generic::__ANON__ > > It appears that the login is the problem. But...if my test > program uses a > straight DBI/DBD call and Rose is not used at all, then there > is no login > delay. It only happens when I login via Rose. > > But now don't know where to go next. Does this new > information give anyone > some clue that will let them suggest what a next sensible > move would be? > > Is there some way of logging what Rose is doing? > > I've used DBI->trace to see what both methods do around the > login time. > They're slightly different as Rose has a lengthier syntax for > the arguments > but I can't see anything that is obviously dodgy. > > > [btw, is it OK that a single simple database call produces > 18K calls to > MakeMethods::Generic__ANON__]? > > > -------------------------------------------------------------- > ----------- > 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
