"Executed 908 queries in 276.55 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 86939.86 ms." While the query count is enormous, Devel is kind of pointing the finger at PHP. This is not the fastest laptop available (but it was supplied by the company). Is there anything that can be done to speed this up? If I update anything on the page, we're talking a three minute round-trip here; my memory is not that long. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
I had this issue. In my case, I was running the server on my laptop in linux under vbox, but the db was in a shared directory on windows. Moving the db to linux made all the difference. Ayen Designs - quality software the first time, every time! -----Original Message----- From: nan wich <nan_wich@bellsouth.net> Sender: development-bounces@drupal.org Date: Sun, 26 Dec 2010 20:14:58 To: development<development@drupal.org> Reply-To: development@drupal.org Subject: [development] The age-old modues admin question "Executed 908 queries in 276.55 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 86939.86 ms." While the query count is enormous, Devel is kind of pointing the finger at PHP. This is not the fastest laptop available (but it was supplied by the company). Is there anything that can be done to speed this up? If I update anything on the page, we're talking a three minute round-trip here; my memory is not that long. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
Thanks, Jeff. Unfortunately, Windoze is my only option. Nor may I install any accelerators. I can, but do not really want to, switch from everything in sites/all/modules to more customized site/site-name/modules (I am maintaining 7 sites with this PC). Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr. ________________________________ From: "jeff@ayendesigns.com" <jeff@ayendesigns.com> To: development@drupal.org Sent: Sun, December 26, 2010 11:20:43 PM Subject: Re: [development] The age-old modues admin question I had this issue. In my case, I was running the server on my laptop in linux under vbox, but the db was in a shared directory on windows. Moving the db to linux made all the difference. Ayen Designs - quality software the first time, every time! ________________________________ From: nan wich <nan_wich@bellsouth.net> Sender: development-bounces@drupal.org Date: Sun, 26 Dec 2010 20:14:58 -0800 (PST) To: development<development@drupal.org> ReplyTo: development@drupal.org Subject: [development] The age-old modues admin question "Executed 908 queries in 276.55 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 86939.86 ms." While the query count is enormous, Devel is kind of pointing the finger at PHP. This is not the fastest laptop available (but it was supplied by the company). Is there anything that can be done to speed this up? If I update anything on the page, we're talking a three minute round-trip here; my memory is not that long. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
Ah, then something else is bogging you down. By the way, for anyone else following, just to clarify what I'd sent, it's not that being on Linux is better (even though it is), but that the db being on a different file system than the site was what had been killing my performance. Jeff On 12/27/2010 12:03 AM, nan wich wrote:
Thanks, Jeff. Unfortunately, Windoze is my only option. Nor may I install any accelerators. I can, but do not really want to, switch from everything in sites/all/modules to more customized site/site-name/modules (I am maintaining 7 sites with this PC).
On Mon, Dec 27, 2010 at 12:03 AM, nan wich <nan_wich@bellsouth.net> wrote:
Thanks, Jeff. Unfortunately, Windoze is my only option. Nor may I install any accelerators.
Jeff mentioned Virtualbox. Is installing virtualization software, which runs on Windows, but provides an environment in which you can use opcode caching, an option? Best, Ezra Ezra Barnett Gildesgame | http://growingventuresolutions.com | http://ezra-g.com
Other than what Zend provides, no, I cannot install any other software, especially if it's not free. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr. ________________________________ From: Ezra B. Gildesgame <ezra@growingventuresolutions.com> To: development@drupal.org Sent: Mon, December 27, 2010 12:23:49 AM Subject: Re: [development] The age-old modues admin question On Mon, Dec 27, 2010 at 12:03 AM, nan wich <nan_wich@bellsouth.net> wrote:
Thanks, Jeff. Unfortunately, Windoze is my only option. Nor may I install any accelerators.
Jeff mentioned Virtualbox. Is installing virtualization software, which runs on Windows, but provides an environment in which you can use opcode caching, an option? Best, Ezra Ezra Barnett Gildesgame | http://growingventuresolutions.com | http://ezra-g.com
Virtualbox is free, and allows you then to run another virtual computer (like linux) in a window. That said, while it all is free, it is no minor thing to get a linux dev environment up if you never did it before, and may not fix the issue at all. Ayen Designs - quality software the first time, every time! -----Original Message----- From: nan wich <nan_wich@bellsouth.net> Sender: development-bounces@drupal.org Date: Mon, 27 Dec 2010 08:00:39 To: <development@drupal.org> Reply-To: development@drupal.org Subject: Re: [development] The age-old modues admin question Other than what Zend provides, no, I cannot install any other software, especially if it's not free. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr. ________________________________ From: Ezra B. Gildesgame <ezra@growingventuresolutions.com> To: development@drupal.org Sent: Mon, December 27, 2010 12:23:49 AM Subject: Re: [development] The age-old modues admin question On Mon, Dec 27, 2010 at 12:03 AM, nan wich <nan_wich@bellsouth.net> wrote:
Thanks, Jeff. Unfortunately, Windoze is my only option. Nor may I install any accelerators.
Jeff mentioned Virtualbox. Is installing virtualization software, which runs on Windows, but provides an environment in which you can use opcode caching, an option? Best, Ezra Ezra Barnett Gildesgame | http://growingventuresolutions.com | http://ezra-g.com
Nancy, If you are running under Windows, there is an issue with MySQL if you are using the InnoDB storage engine. MySQL waits for confirmations from Windows that never come, so it takes a very long time for some queries to execute. To get around this, add the following directive to your my.cnf file: innodb_flush_log_at_trx_commit = 2 This might help to speed things up. Thanks, Chris On Mon, Dec 27, 2010 at 11:04 AM, <jeff@ayendesigns.com> wrote:
Virtualbox is free, and allows you then to run another virtual computer (like linux) in a window. That said, while it all is free, it is no minor thing to get a linux dev environment up if you never did it before, and may not fix the issue at all.
Ayen Designs - quality software the first time, every time! ------------------------------ *From: * nan wich <nan_wich@bellsouth.net> *Sender: * development-bounces@drupal.org *Date: *Mon, 27 Dec 2010 08:00:39 -0800 (PST) *To: *<development@drupal.org> *ReplyTo: * development@drupal.org *Subject: *Re: [development] The age-old modues admin question
Other than what Zend provides, no, I cannot install any other software, especially if it's not free.
*Nancy*
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
------------------------------ *From:* Ezra B. Gildesgame <ezra@growingventuresolutions.com> *To:* development@drupal.org *Sent:* Mon, December 27, 2010 12:23:49 AM *Subject:* Re: [development] The age-old modues admin question
On Mon, Dec 27, 2010 at 12:03 AM, nan wich <nan_wich@bellsouth.net> wrote:
Thanks, Jeff. Unfortunately, Windoze is my only option. Nor may I install any accelerators.
Jeff mentioned Virtualbox. Is installing virtualization software, which runs on Windows, but provides an environment in which you can use opcode caching, an option?
Best, Ezra
Ezra Barnett Gildesgame | http://growingventuresolutions.com | http://ezra-g.com
This is on D6, so, it's not Innodb. With Devel attributing less than one third of 1% of the time to MySql, I'm not even looking there. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr. ________________________________ From: Chris Pliakas <cpliakas@gmail.com> To: development@drupal.org; jeff@ayendesigns.com Sent: Mon, December 27, 2010 11:14:10 AM Subject: Re: [development] The age-old modues admin question Nancy, If you are running under Windows, there is an issue with MySQL if you are using the InnoDB storage engine. MySQL waits for confirmations from Windows that never come, so it takes a very long time for some queries to execute. To get around this, add the following directive to your my.cnf file: innodb_flush_log_at_trx_commit = 2 This might help to speed things up. Thanks, Chris On Mon, Dec 27, 2010 at 11:04 AM, <jeff@ayendesigns.com> wrote: Virtualbox is free, and allows you then to run another virtual computer (like linux) in a window. That said, while it all is free, it is no minor thing to get a linux dev environment up if you never did it before, and may not fix the issue at all.
Ayen Designs - quality software the first time, every time!
From: nan wich <nan_wich@bellsouth.net> Sender: development-bounces@drupal.org Date: Mon, 27 Dec 2010 08:00:39 -0800 (PST) To: <development@drupal.org> ReplyTo: development@drupal.org Subject: Re: [development] The age-old modues admin question
Other than what Zend provides, no, I cannot install any other software, especially if it's not free.
Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
________________________________ From: Ezra B. Gildesgame <ezra@growingventuresolutions.com>
To: development@drupal.org Sent: Mon, December 27, 2010 12:23:49 AM Subject: Re: [development] The age-old modues admin question
On Mon, Dec 27, 2010 at 12:03 AM, nan wich <nan_wich@bellsouth.net> wrote:
Thanks, Jeff. Unfortunately, Windoze is my only option. Nor may I install any accelerators.
Jeff mentioned Virtualbox. Is installing virtualization software, which runs on Windows, but provides an environment in which you can use opcode caching, an option?
Best, Ezra
Ezra Barnett Gildesgame | http://growingventuresolutions.com | http://ezra-g.com
Hey Nancy, Have you looked at task manager to confirm where the processing is going? 9 out of 10 times my dev environment performance problems have been antivirus related. Try temporarily turning off on access scanning and see if that helps. Dave Sent from my iPad On Dec 27, 2010, at 8:56 AM, nan wich <nan_wich@bellsouth.net> wrote:
This is on D6, so, it's not Innodb. With Devel attributing less than one third of 1% of the time to MySql, I'm not even looking there.
Nancy
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
From: Chris Pliakas <cpliakas@gmail.com> To: development@drupal.org; jeff@ayendesigns.com Sent: Mon, December 27, 2010 11:14:10 AM Subject: Re: [development] The age-old modues admin question
Nancy,
If you are running under Windows, there is an issue with MySQL if you are using the InnoDB storage engine. MySQL waits for confirmations from Windows that never come, so it takes a very long time for some queries to execute. To get around this, add the following directive to your my.cnf file:
innodb_flush_log_at_trx_commit = 2
This might help to speed things up.
Thanks, Chris
On Mon, Dec 27, 2010 at 11:04 AM, <jeff@ayendesigns.com> wrote: Virtualbox is free, and allows you then to run another virtual computer (like linux) in a window. That said, while it all is free, it is no minor thing to get a linux dev environment up if you never did it before, and may not fix the issue at all. Ayen Designs - quality software the first time, every time!
From: nan wich <nan_wich@bellsouth.net> Sender: development-bounces@drupal.org Date: Mon, 27 Dec 2010 08:00:39 -0800 (PST) To: <development@drupal.org> ReplyTo: development@drupal.org Subject: Re: [development] The age-old modues admin question
Other than what Zend provides, no, I cannot install any other software, especially if it's not free.
Nancy
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
From: Ezra B. Gildesgame <ezra@growingventuresolutions.com> To: development@drupal.org Sent: Mon, December 27, 2010 12:23:49 AM Subject: Re: [development] The age-old modues admin question
On Mon, Dec 27, 2010 at 12:03 AM, nan wich <nan_wich@bellsouth.net> wrote:
Thanks, Jeff. Unfortunately, Windoze is my only option. Nor may I install any accelerators.
Jeff mentioned Virtualbox. Is installing virtualization software, which runs on Windows, but provides an environment in which you can use opcode caching, an option?
Best, Ezra
Ezra Barnett Gildesgame | http://growingventuresolutions.com | http://ezra-g.com
I have seen that also, especially with Windows Security Essentials. Add your source code and AMP directories to the exceptions list and that helps. It also plays havoc if you are doing any version control when you try to update or commit. If that isn't the problem, I suggest switching to WAMPServer 2.0. I've been running that for a couple of years and haven't had any problems, plus you can enable op-code caching like APC with a simple right click on the task bar icon for WAMP. Jamie Holly http://www.intoxination.net http://www.hollyit.net On 12/27/2010 12:33 PM, Dave Metzler wrote:
Hey Nancy,
Have you looked at task manager to confirm where the processing is going? 9 out of 10 times my dev environment performance problems have been antivirus related. Try temporarily turning off on access scanning and see if that helps.
Dave
Sent from my iPad
On Dec 27, 2010, at 8:56 AM, nan wich <nan_wich@bellsouth.net <mailto:nan_wich@bellsouth.net>> wrote:
This is on D6, so, it's not Innodb. With Devel attributing less than one third of 1% of the time to MySql, I'm not even looking there.
/*Nancy*/
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
------------------------------------------------------------------------ *From:* Chris Pliakas <cpliakas@gmail.com <mailto:cpliakas@gmail.com>> *To:* development@drupal.org <mailto:development@drupal.org>; jeff@ayendesigns.com <mailto:jeff@ayendesigns.com> *Sent:* Mon, December 27, 2010 11:14:10 AM *Subject:* Re: [development] The age-old modues admin question
Nancy,
If you are running under Windows, there is an issue with MySQL if you are using the InnoDB storage engine. MySQL waits for confirmations from Windows that never come, so it takes a very long time for some queries to execute. To get around this, add the following directive to your my.cnf file:
innodb_flush_log_at_trx_commit = 2
This might help to speed things up.
Thanks, Chris
On Mon, Dec 27, 2010 at 11:04 AM, <jeff@ayendesigns.com <mailto:jeff@ayendesigns.com>> wrote:
Virtualbox is free, and allows you then to run another virtual computer (like linux) in a window. That said, while it all is free, it is no minor thing to get a linux dev environment up if you never did it before, and may not fix the issue at all.
Ayen Designs - quality software the first time, every time!
------------------------------------------------------------------------ *From: *nan wich <nan_wich@bellsouth.net <mailto:nan_wich@bellsouth.net>> *Sender: *development-bounces@drupal.org <mailto:development-bounces@drupal.org> *Date: *Mon, 27 Dec 2010 08:00:39 -0800 (PST) *To: *<development@drupal.org <mailto:development@drupal.org>> *ReplyTo: *development@drupal.org <mailto:development@drupal.org> *Subject: *Re: [development] The age-old modues admin question
Other than what Zend provides, no, I cannot install any other software, especially if it's not free.
/*Nancy*/
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
------------------------------------------------------------------------ *From:* Ezra B. Gildesgame <ezra@growingventuresolutions.com <mailto:ezra@growingventuresolutions.com>> *To:* development@drupal.org <mailto:development@drupal.org> *Sent:* Mon, December 27, 2010 12:23:49 AM *Subject:* Re: [development] The age-old modues admin question
On Mon, Dec 27, 2010 at 12:03 AM, nan wich <nan_wich@bellsouth.net <mailto:nan_wich@bellsouth.net>> wrote: > Thanks, Jeff. Unfortunately, Windoze is my only option. Nor may I install > any accelerators.
Jeff mentioned Virtualbox. Is installing virtualization software, which runs on Windows, but provides an environment in which you can use opcode caching, an option?
Best, Ezra
Ezra Barnett Gildesgame | http://growingventuresolutions.com | http://ezra-g.com
They have probably the most intrusive AVP installed, Symantec. They also seem to prevent me from making any updates to it. But that sounds like a reasonable potentiality. I guess I'll know better when I get my own computer back next week. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr. ________________________________ From: Jamie Holly <hovercrafter@earthlink.net> To: development@drupal.org Sent: Mon, December 27, 2010 12:52:51 PM Subject: Re: [development] The age-old modues admin question I have seen that also, especially with Windows Security Essentials. Add your source code and AMP directories to the exceptions list and that helps. It also plays havoc if you are doing any version control when you try to update or commit. If that isn't the problem, I suggest switching to WAMPServer 2.0. I've been running that for a couple of years and haven't had any problems, plus you can enable op-code caching like APC with a simple right click on the task bar icon for WAMP. Jamie Holly http://www.intoxination.net http://www.hollyit.net On 12/27/2010 12:33 PM, Dave Metzler wrote: Hey Nancy,
Have you looked at task manager to confirm where the processing is going? 9 out of 10 times my dev environment performance problems have been antivirus related. Try temporarily turning off on access scanning and see if that helps.
Dave
Sent from my iPad
On Dec 27, 2010, at 8:56 AM, nan wich <nan_wich@bellsouth.net> wrote:
This is on D6, so, it's not Innodb. With Devel attributing less than one third of 1% of the time to MySql, I'm not even looking there.
Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
________________________________ From: Chris Pliakas <cpliakas@gmail.com>
To: development@drupal.org; jeff@ayendesigns.com Sent: Mon, December 27, 2010 11:14:10 AM Subject: Re: [development] The age-old modues admin question
Nancy,
If you are running under Windows, there is an issue with MySQL if you are using the InnoDB storage engine. MySQL waits for confirmations from Windows that never come, so it takes a very long time for some queries to execute. To get around this, add the following directive to your my.cnf file:
innodb_flush_log_at_trx_commit = 2
This might help to speed things up.
Thanks, Chris
On Mon, Dec 27, 2010 at 11:04 AM, <jeff@ayendesigns.com> wrote:
Virtualbox is free, and allows you then to run another virtual computer (like linux) in a window. That said, while it all is free, it is no minor thing to get a linux dev environment up if you never did it before, and may not fix the issue at all.
Ayen Designs - quality software the first time, every time!
From: nan wich <nan_wich@bellsouth.net> Sender: development-bounces@drupal.org Date: Mon, 27 Dec 2010 08:00:39 -0800 (PST) To: <development@drupal.org> ReplyTo: development@drupal.org Subject: Re: [development] The age-old modues admin question
Other than what Zend provides, no, I cannot install any other software, especially if it's not free.
Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
From: Ezra B. Gildesgame <ezra@growingventuresolutions.com>
To: development@drupal.org Sent: Mon, December 27, 2010 12:23:49 AM Subject: Re: [development] The age-old modues admin question
On Mon, Dec 27, 2010 at 12:03 AM, nan wich <nan_wich@bellsouth.net> wrote:
Thanks, Jeff. Unfortunately, Windoze is my only option. Nor may I install any accelerators.
Jeff mentioned Virtualbox. Is installing virtualization software, which runs on Windows, but provides an environment in which you can use opcode caching, an option?
Best, Ezra
Ezra Barnett Gildesgame | http://growingventuresolutions.com | http://ezra-g.com
It sounds like you have one or more nasty loops or some bad recursion going on. I'd highly recommend profiling the execution using xdebug and WinCacheGrind. This page has a pretty good tutorial. http://www.xdebug.org/docs/profiler You can use WinCacheGrind to locate and drill down the execution branch that is consuming all the time until you find the offending function. Dale On Mon, Dec 27, 2010 at 8:56 AM, nan wich <nan_wich@bellsouth.net> wrote:
This is on D6, so, it's not Innodb. With Devel attributing less than one third of 1% of the time to MySql, I'm not even looking there.
*Nancy*
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
------------------------------ *From:* Chris Pliakas <cpliakas@gmail.com> *To:* development@drupal.org; jeff@ayendesigns.com *Sent:* Mon, December 27, 2010 11:14:10 AM
*Subject:* Re: [development] The age-old modues admin question
Nancy,
If you are running under Windows, there is an issue with MySQL if you are using the InnoDB storage engine. MySQL waits for confirmations from Windows that never come, so it takes a very long time for some queries to execute. To get around this, add the following directive to your my.cnf file:
innodb_flush_log_at_trx_commit = 2
This might help to speed things up.
Thanks, Chris
On Mon, Dec 27, 2010 at 11:04 AM, <jeff@ayendesigns.com> wrote:
Virtualbox is free, and allows you then to run another virtual computer (like linux) in a window. That said, while it all is free, it is no minor thing to get a linux dev environment up if you never did it before, and may not fix the issue at all.
Ayen Designs - quality software the first time, every time! ------------------------------ *From: *nan wich <nan_wich@bellsouth.net> *Sender: *development-bounces@drupal.org *Date: *Mon, 27 Dec 2010 08:00:39 -0800 (PST) *To: *<development@drupal.org> *ReplyTo: *development@drupal.org *Subject: *Re: [development] The age-old modues admin question
Other than what Zend provides, no, I cannot install any other software, especially if it's not free.
*Nancy*
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
------------------------------ *From:* Ezra B. Gildesgame <ezra@growingventuresolutions.com> *To:* development@drupal.org *Sent:* Mon, December 27, 2010 12:23:49 AM *Subject:* Re: [development] The age-old modues admin question
On Mon, Dec 27, 2010 at 12:03 AM, nan wich <nan_wich@bellsouth.net> wrote:
Thanks, Jeff. Unfortunately, Windoze is my only option. Nor may I install any accelerators.
Jeff mentioned Virtualbox. Is installing virtualization software, which runs on Windows, but provides an environment in which you can use opcode caching, an option?
Best, Ezra
Ezra Barnett Gildesgame | http://growingventuresolutions.com | http://ezra-g.com
I've noticed turning off the Firebug module saves a lot of memory and queries. Any chance you're running it? In fact, have you looked at the MySQL slow log to see if anything is bogging it down? =Don- On 12/27/2010 12:03 AM, nan wich wrote:
Thanks, Jeff. Unfortunately, Windoze is my only option. Nor may I install any accelerators. I can, but do not really want to, switch from everything in sites/all/modules to more customized site/site-name/modules (I am maintaining 7 sites with this PC).
/*Nancy*/
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
------------------------------------------------------------------------ *From:* "jeff@ayendesigns.com" <jeff@ayendesigns.com> *To:* development@drupal.org *Sent:* Sun, December 26, 2010 11:20:43 PM *Subject:* Re: [development] The age-old modues admin question
I had this issue. In my case, I was running the server on my laptop in linux under vbox, but the db was in a shared directory on windows. Moving the db to linux made all the difference.
Ayen Designs - quality software the first time, every time!
------------------------------------------------------------------------ *From: *nan wich <nan_wich@bellsouth.net> *Sender: *development-bounces@drupal.org *Date: *Sun, 26 Dec 2010 20:14:58 -0800 (PST) *To: *development<development@drupal.org> *ReplyTo: *development@drupal.org *Subject: *[development] The age-old modues admin question
"Executed 908 queries in 276.55 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 86939.86 ms." While the query count is enormous, Devel is kind of pointing the finger at PHP. This is not the fastest laptop available (but it was supplied by the company). Is there anything that can be done to speed this up? If I update anything on the page, we're talking a three minute round-trip here; my memory is not that long.
/*Nancy*/
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
This seems excessive even for win. What web server and version are you using? This message was typed on a mobile device. Please excuse any errors. On 27/12/2010 4:43 PM, "Don" <donald@fane.com> wrote: I've noticed turning off the Firebug module saves a lot of memory and queries. Any chance you're running it? In fact, have you looked at the MySQL slow log to see if anything is bogging it down? =Don- On 12/27/2010 12:03 AM, nan wich wrote:
Thanks, Jeff. Unfortunately, Windoze is my only option...
Apache 2.2.6 MySql 5.0.45 - 32 MB query cache PHP 5.2.5 Windows XP SP2 Dell Latitude D630, 4GB Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr. ________________________________ From: Christopher Skene <chris@xtfer.com> To: development@drupal.org Sent: Mon, December 27, 2010 12:53:55 AM Subject: Re: [development] The age-old modues admin question This seems excessive even for win. What web server and version are you using? This message was typed on a mobile device. Please excuse any errors. On 27/12/2010 4:43 PM, "Don" <donald@fane.com> wrote:
I've noticed turning off the Firebug module saves a lot of memory and queries. Any chance you're running it? In fact, have you looked at the MySQL slow log to see if anything is bogging it down?
=Don-
On 12/27/2010 12:03 AM, nan wich wrote:
Thanks, Jeff. Unfortunately, Windoze is my only option...
Yes, I have Firebug, but I don't use it on the modules admin page. Given that MySql is taking a quarter of one second out of almost 90 seconds, I seiously doubt that's where the issue is. I would be far more likely to suspect all the disk file reading that has to be done, but Devel doesn't track that. I have considered putting a hack into the module to track it. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr. ________________________________ From: Don <donald@fane.com> To: development@drupal.org Sent: Mon, December 27, 2010 12:43:12 AM Subject: Re: [development] The age-old modues admin question I've noticed turning off the Firebug module saves a lot of memory and queries. Any chance you're running it? In fact, have you looked at the MySQL slow log to see if anything is bogging it down? =Don- On 12/27/2010 12:03 AM, nan wich wrote: Thanks, Jeff. Unfortunately, Windoze is my only option. Nor may I install any accelerators. I can, but do not really want to, switch from everything in sites/all/modules to more customized site/site-name/modules (I am maintaining 7 sites with this PC).
Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
________________________________ From: "jeff@ayendesigns.com" <jeff@ayendesigns.com>
To: development@drupal.org Sent: Sun, December 26, 2010 11:20:43 PM Subject: Re: [development] The age-old modues admin question
I had this issue. In my case, I was running the server on my laptop in linux under vbox, but the db was in a shared directory on windows. Moving the db to linux made all the difference.
Ayen Designs - quality software the first time, every time!
From: nan wich <nan_wich@bellsouth.net> Sender: development-bounces@drupal.org Date: Sun, 26 Dec 2010 20:14:58 -0800 (PST) To: development<development@drupal.org> ReplyTo: development@drupal.org Subject: [development] The age-old modues admin question
"Executed 908 queries in 276.55 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 86939.86 ms."
While the query count is enormous, Devel is kind of pointing the finger at PHP. This is not the fastest laptop available (but it was supplied by the company). Is there anything that can be done to speed this up? If I update anything on the page, we're talking a three minute round-trip here; my memory is not that long. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
I experienced similar slowness with Drupal trying to access remote contents (eg. updates check - rss updating) while running my dev site in a very slow network or in a firewalled/proxied network. You might want to disable automatic update checks. Personally, I couldn't work for a company which wouldn't let me install what I want on my work PC, expecially if that would mean using Windows every day. On 12/27/2010 05:14 AM, nan wich wrote:
"Executed 908 queries in 276.55 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 86939.86 ms."
While the query count is enormous, Devel is kind of pointing the finger at PHP. This is not the fastest laptop available (but it was supplied by the company). Is there anything that can be done to speed this up? If I update anything on the page, we're talking a three minute round-trip here; my memory is not that long.
/*Nancy*/
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
The reason why I don't want to install anything is because my contract expires on Friday. That limits installation and learning time. On none of the sites do I use Aggregator on my copy. And on the most eggregiously slow site, I am not using Update either. At this point, I am going to bet on a) severly slow laptop, b) Symantec virus scanning. BTW, on the production version of this site, the modules admin page loads in just under one second. I know that server is much faster, quad-core, and doesn't run virus scans the same way (if at all). And it is virtualized Ubuntu Linux. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr. ________________________________ From: Fabio Varesano <fabio.varesano@gmail.com> To: development@drupal.org Sent: Mon, December 27, 2010 3:01:10 PM Subject: Re: [development] The age-old modues admin question I experienced similar slowness with Drupal trying to access remote contents (eg. updates check - rss updating) while running my dev site in a very slow network or in a firewalled/proxied network. You might want to disable automatic update checks. Personally, I couldn't work for a company which wouldn't let me install what I want on my work PC, expecially if that would mean using Windows every day. On 12/27/2010 05:14 AM, nan wich wrote:
"Executed 908 queries in 276.55 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 86939.86 ms." While the query count is enormous, Devel is kind of pointing the finger at PHP. This is not the fastest laptop available (but it was supplied by the company). Is there anything that can be done to speed this up? If I update anything on the page, we're talking a three minute round-trip here; my memory is not that long.
/*Nancy*/
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
participants (10)
-
Chris Pliakas -
Christopher Skene -
Dale Clarke -
Dave Metzler -
Don -
Ezra B. Gildesgame -
Fabio Varesano -
Jamie Holly -
jeff＠ayendesigns.com -
nan wich