drupal performs really slowly ...
hi, ive found that my drupal installation performs really slowly when i have quite a few modules installed and running - it also gives me mysql timeout errors and stuff like that. I went and changed my php timeout to 300 seconds in the php.ini file because it kept on timeing out at 30 seconds.
I do not think that chaning the timeout for php is a long term fix of the problem. Is there any way to govern the speed of drupal? also the control panel is quite slow from time to time. Is this database trouble or just the speed of my server (windows xp, pro pentium 4, 2.5 ghz, 512 mb ram, wampserver 2) that is perhaps not quite fast enough. I am actually using my workstation at the moment as a webserver with wampserver as i have not completed my configurations on my local fedora linux server.
Please could someone assist me with the latency issue as i dont really know if it is supposed to be this slow. I notice that when wordpress has a lot of modules installed and activated that it is not as slow as this - it may slow down slightly but it does not die and timeout and give me errors and stuff like that.
I am working on running a sorta social network and therefore need to have a number of plugins activated and installed.
thanks ... :)
=-=
first note: you are posting in a deprecated forum. There may not be many eyes left to see this thread because of this choice. Deprecated forums aren't as active and are easily overlooked these days.
onward with your issue:
have you run the devel.module to figure out how many queries are getting called ?
what does "quite a few" modules mean ?
have you done any benchmarking ?
are you using caching ?
MySQL optimisations ?
what I can tell you is a P4 2.5 ghz machine already running windows isn't a server. While it will provide a server environment its isn't like you have a dedicated linux box.
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
ok
i know that windows is not a server, that it why i said that i am using it while i am finishing my fedora installation.
Ummm... i am running more than 30 - and there is cck, view, devel, charts, and quite a few more
----------------------------------
spreading the love... :)
http://www.espresso-online.info
=-=
some benchmarking and debugging information on your part would be super informative.
optimizing mysql for drupal = http://www.google.com/search?hl=en&sa=X&oi=spell&resnum=0&ct=result&cd=1...
quite a bit of informative posts by kbahey = http://2bits.com/contents/articles
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
hmmm
yes, it seems that mysql is not performing as quickly as it could be, thank you for the link.
----------------------------------
spreading the love... :)
http://www.espresso-online.info
maybe drupal sucks
As much as I like drupal and the power that seems to be there - I have this sneeky suspicion that it has inherent design flaws that cause it to be slow and slower. Maybe it is the core, maybe sloppy modules but I don't see this issue discussed.
Slow page loads means lost visitors - it is that simple.
In terms of your set up ( I use a similar arrangement MAMP on my Mac iBook) and I think you need to install more memory. In spite of this fact timing out at 30 seconds suggests something very wrong.
yah
yah i know that - but i am not going to host this site locally forever as i hope to launch it onto the internet quite soon and i do not really want these speed issues to cause me any problems.
i think that the problem with drupal is that they are performing far too many sql queries at the same time - i may be wrong but i am willing to be put straight. maybe someone can explain to me how the core makes queries.
----------------------------------
spreading the love... :)
http://www.espresso-online.info
=-=
if you use the devel.module you can see what querries are being called and where and if there are any duplicates.
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
=-=
proper debugging information and benchmarks go a long long way.
Also note there are many discussions about there types of issues. There are also others benchmarks and debugging information. Many share their experiences and what they've done to optimise they server.
Simple fact: a social netorking environment to work 100% efficently for 100s of logged in users plus 100s of anon users will need more of a cluster of servers rather then a shared hostsing environment or a VPS.
a site with "quite a few" modules will each up resources and need to be optimized in more then one way.
there are quite a few large sites these days powered by drupal which speaks volumes.
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
i agree
i agree that there are quite a lot of large websites that make use of drupal and i really think that it is a really great framework. i know that a social networking site needs to have many clusters of servers but i am talking, at the moment, of just 1 user using a pc that is not actually doing much.
as i have said before, why must every drupal module use more and more resources - y cant they only use resources as they are needed, but to activate/deactivate them should not really timeout, unless there is more to the backend than i am actually seeing. This causes me to think of drupal much as i, and many other developers do, think of ruby - where ruby does not scale and the only way that you can cause ruby to run faster is by adding more powerful servers to it.
----------------------------------
spreading the love... :)
http://www.espresso-online.info
=-=
My comment above was a response to http://drupal.org/node/259401#comment-846840
you can hop in the code, as teams like teamsugar have and optimse code and reduce querries. you can run php cache ie: memcache and the like, there are many helper modules coming to market that harness this kind of power.
Drupal is query hungry but this hunger can be calmed with a small salad here and there instead of a four course meal, if you dig deeper and locate the exact source of the problem.
I personally, On a winxp machine, I partition the HD and run a flavor of linux on said partition which allows me to use resources that Windows takes away.
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
ok so ...
ok so to get a solution to my problem, what modules would i be able to download to fix it?
----------------------------------
spreading the love... :)
http://www.espresso-online.info
=-=
The first thing is to diagnose it.
have you installed the devel.module as previously mentioned and inspected what is going on with regards to querries ?
which ones are slow ?
are there any duplicates ?
also see: http://drupal.org/node/51263 & and related information here: http://drupal.org/node/21875
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )
yup
yup i installed devel. i think im figuring it out. thanks
----------------------------------
spreading the love... :)
http://www.espresso-online.info