Trac 1.0 with postgres - slow response
81 views
Skip to first unread message
gmk
Oct 2, 2012, 5:34:08 PM10/2/12
to trac-...@googlegroups.com
Hi,
our trac installation reacts very slow on some operations
For ex.
Create New ticket: takes about >40 seconds until the input form is displayed
Timeline View: (30 Days back) takes >30 seconds
My environment ist:
Debian Squeeze
Postgres 8.4
Trac 1.0
TracMasterTickets-3.0.2
TracQueues-0.1.0
TracDirectoryAuth-0.5
BreadCrumbsNav-0.3dev_r10902
Tracchildtickets-2.5.2
TracCustomFieldAdmin-0.2.8_r11597
TracDynamicFields-2.2.0dev
graphviz-0.7.6dev_r11464
IniAdmin-0.2_r11914
timingandestimationplugin-1.3.0b
TracWikiPrintPlugin-1.9.2
worklog-0.3dev_r12090
TracXMLRPC-1.1.2_r11439
TracTags-0.7dev_r12079
TracAccountManager-0.3.2
Is there a way to find out with module takes the time?
Regards,
Gernot
Steffen Hoffmann
Oct 2, 2012, 6:01:57 PM10/2/12
to trac-...@googlegroups.com
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 02.10.2012 23:34, gmk wrote:
> Is there a way to find out with module takes the time?
Not straight, but enable DEBUG logging and SQL logging to see, where
it's getting stalled.
If you'll need more, you have to do request profiling [1][2]. Especially
osimons's solution has reportedly been used with success before.
Steffen Hoffmann
[1] http://stackoverflow.com/questions/5511301
[2] http://trac.edgewall.org/wiki/TracPerformance
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEUEARECAAYFAlBrZFMACgkQ31DJeiZFuHf1ZQCWK/JohLu+B/aCf6f8+Km+Eks4
NgCgnH7dMWdmAnIeQZXg/qtw8cdeTiE=
=AEU2
-----END PGP SIGNATURE-----
Hash: SHA1
On 02.10.2012 23:34, gmk wrote:
> Is there a way to find out with module takes the time?
it's getting stalled.
If you'll need more, you have to do request profiling [1][2]. Especially
osimons's solution has reportedly been used with success before.
Steffen Hoffmann
[1] http://stackoverflow.com/questions/5511301
[2] http://trac.edgewall.org/wiki/TracPerformance
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEUEARECAAYFAlBrZFMACgkQ31DJeiZFuHf1ZQCWK/JohLu+B/aCf6f8+Km+Eks4
NgCgnH7dMWdmAnIeQZXg/qtw8cdeTiE=
=AEU2
-----END PGP SIGNATURE-----
Olemis Lang
Oct 2, 2012, 7:14:56 PM10/2/12
to trac-...@googlegroups.com
On 10/2/12, Steffen Hoffmann <hof...@web.de> wrote:
> On 02.10.2012 23:34, gmk wrote:
>> Is there a way to find out with module takes the time?
>
[...]
> On 02.10.2012 23:34, gmk wrote:
>> Is there a way to find out with module takes the time?
>
>
> If you'll need more, you have to do request profiling [1][2]. Especially
> osimons's solution has reportedly been used with success before.
>
fwiw ... +1
> If you'll need more, you have to do request profiling [1][2]. Especially
> osimons's solution has reportedly been used with success before.
>
--
Regards,
Olemis.
Blog ES: http://simelo-es.blogspot.com/
Blog EN: http://simelo-en.blogspot.com/
Featured article:
RjOllos
Oct 10, 2012, 4:58:51 PM10/10/12
to trac-...@googlegroups.com
On Sunday, October 7, 2012 8:02:15 AM UTC-7, numo68 wrote:
[...[
Well... is there any way to cache the result instead of each time traversing half of the LDAP? Or a way to only use LDAP only for the login and get groups and permissions in some more efficient way?
I'm not sure how much it will help, but you may want to take a look at (1), where the code you mention was discussed.
Reply all
Reply to author
Forward
0 new messages