[Agilo for Trac] Help to clean up agilo/trac Database

[s***@public.gmane.org]

Hi guyz,

We are using agilo/trac since last 2 years. But from last 2months trac has
become to slow.
It takes around 3-5 mins to update/create ticket.

So I wanted to ask that is there any way to clean up trac database to
increase speed, without breaking current trac settings.
So can we remove previous sprints data which are not in use.

Please do help.

Thanks and regards.
Shafi R. Dayatar
--
--
Follow Agilo on Twitter: http://twitter.com/agilofortrac
Please support us by reviewing and voting on:
http://userstories.com/products/8-agilo-for-scrum
http://ohloh.net/p/agilo-trac
http://freshmeat.net/projects/agiloforscrum

You have received this message because you are subscribed to
the "Agilo for Trac" Google Group. This group is focused on
supporting Agilo for Trac users and is moderated by
Agilo Software GmbH <http://www.agilosoftware.com>.

To post to this group, send email to agilo-/***@public.gmane.org
To unsubscribe from this group, send an email to
agilo+unsubscribe-/***@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/agilo

---
You received this message because you are subscribed to the Google Groups "Agilo for Trac" group.
To unsubscribe from this group and stop receiving emails from it, send an email to agilo+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/***@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.

[Dean Millam]

What database backend are you using?

Post by s***@public.gmane.org
Hi guyz,
We are using agilo/trac since last 2 years. But from last 2months trac has
become to slow.
It takes around 3-5 mins to update/create ticket.
So I wanted to ask that is there any way to clean up trac database to
increase speed, without breaking current trac settings.
So can we remove previous sprints data which are not in use.
Please do help.
Thanks and regards.
Shafi R. Dayatar

--
--
Follow Agilo on Twitter: http://twitter.com/agilofortrac
Please support us by reviewing and voting on:
http://userstories.com/products/8-agilo-for-scrum
http://ohloh.net/p/agilo-trac
http://freshmeat.net/projects/agiloforscrum

You have received this message because you are subscribed to
the "Agilo for Trac" Google Group. This group is focused on
supporting Agilo for Trac users and is moderated by
Agilo Software GmbH <http://www.agilosoftware.com>.

To post to this group, send email to agilo-/***@public.gmane.org
To unsubscribe from this group, send an email to
agilo+unsubscribe-/***@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/agilo

---
You received this message because you are subscribed to the Google Groups "Agilo for Trac" group.
To unsubscribe from this group and stop receiving emails from it, send an email to agilo+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/***@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.

[marco-P/]

Hey,

we got the same problem with agilo trac.
Current ticket nummer is about 6000, and loading become slower and slower
(not that hard, but increases to 5-10 seconds per site/update).
Are there any indices that we can set to specific columns in mysql database?
Or is there another way to speed up the ticket system?

Thanks in advance,
regards
Marco

Post by s***@public.gmane.org
Hi guyz,
We are using agilo/trac since last 2 years. But from last 2months trac has
become to slow.
It takes around 3-5 mins to update/create ticket.
So I wanted to ask that is there any way to clean up trac database to
increase speed, without breaking current trac settings.
So can we remove previous sprints data which are not in use.
Please do help.
Thanks and regards.
Shafi R. Dayatar

--
--
Follow Agilo on Twitter: http://twitter.com/agilofortrac
Please support us by reviewing and voting on:
http://userstories.com/products/8-agilo-for-scrum
http://ohloh.net/p/agilo-trac
http://freshmeat.net/projects/agiloforscrum

You have received this message because you are subscribed to
the "Agilo for Trac" Google Group. This group is focused on
supporting Agilo for Trac users and is moderated by
Agilo Software GmbH <http://www.agilosoftware.com>.

To post to this group, send email to agilo-/***@public.gmane.org
To unsubscribe from this group, send an email to
agilo+unsubscribe-/***@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/agilo

---
You received this message because you are subscribed to the Google Groups "Agilo for Trac" group.
To unsubscribe from this group and stop receiving emails from it, send an email to agilo+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/***@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.

[Claudio Di Cosmo]

Hi Marco,

[agilo-links]
cache.timeout = 0

in order to improve the performance of agilo for trac, you can enable its caching system.
In the Trac.ini there is a cache.timeout variable which by default is 0. It defines how much time (in milliseconds) the cache should be valid after a request.
I suggest you to do some trial starting from a value of 2000 and then increasing the value if not enough.
If you are still experiencing issue, please contact us.

Cheers,

Claudio Di Cosmo
Software Engineer
Agilo Software GmbH
Gruenberger Str. 54
10245 Berlin, Germany

claudio.dicosmo-CKHYNj9aYvRx67MzidHQgQC/***@public.gmane.org
http://www.agilosoftware.com

Follow us on twitter: http://twitter.com/agiloforscrum, http://twitter.com/agilofortrac

Amtsgericht Charlottenburg: HRB 127146
CEO Marion Eickmann, Andrea Tomasini

Hey,
we got the same problem with agilo trac.
Current ticket nummer is about 6000, and loading become slower and slower (not that hard, but increases to 5-10 seconds per site/update).
Are there any indices that we can set to specific columns in mysql database?
Or is there another way to speed up the ticket system?
Thanks in advance,
regards
Marco
Hi guyz,
We are using agilo/trac since last 2 years. But from last 2months trac has become to slow.
It takes around 3-5 mins to update/create ticket.
So I wanted to ask that is there any way to clean up trac database to increase speed, without breaking current trac settings.
So can we remove previous sprints data which are not in use.
Please do help.
Thanks and regards.
Shafi R. Dayatar
--
--
Follow Agilo on Twitter: http://twitter.com/agilofortrac
http://userstories.com/products/8-agilo-for-scrum
http://ohloh.net/p/agilo-trac
http://freshmeat.net/projects/agiloforscrum
You have received this message because you are subscribed to
the "Agilo for Trac" Google Group. This group is focused on
supporting Agilo for Trac users and is moderated by
Agilo Software GmbH <http://www.agilosoftware.com>.
To unsubscribe from this group, send an email to
For more options, visit this group at
http://groups.google.com/group/agilo
---
You received this message because you are subscribed to the Google Groups "Agilo for Trac" group.
For more options, visit https://groups.google.com/groups/opt_out.

--
--
Follow Agilo on Twitter: http://twitter.com/agilofortrac
Please support us by reviewing and voting on:
http://userstories.com/products/8-agilo-for-scrum
http://ohloh.net/p/agilo-trac
http://freshmeat.net/projects/agiloforscrum

You have received this message because you are subscribed to
the "Agilo for Trac" Google Group. This group is focused on
supporting Agilo for Trac users and is moderated by
Agilo Software GmbH <http://www.agilosoftware.com>.

To post to this group, send email to agilo-/***@public.gmane.org
To unsubscribe from this group, send an email to
agilo+unsubscribe-/***@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/agilo

---
You received this message because you are subscribed to the Google Groups "Agilo for Trac" group.
To unsubscribe from this group and stop receiving emails from it, send an email to agilo+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/***@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.