Forum OpenACS Development: Bug Tracker Performance

Collapse
1: Bug Tracker Performance
Posted by Amruta Lakade on 04/25/08 07:11 AM
Can anybody tell me the number of bugs the Bug Tracker can have? I added near around 6000 bugs and it's taking 10-15 mnts to show all the bugs.

Is there a problem in query for fetching bug information?

-Amruta

Collapse
2: Re: Bug Tracker Performance (response to 1)
Posted by Dave Bauer on 04/25/08 07:38 AM
What do you mean by "show all the bugs"
Are you trying to view 6000 items on one page?
That will be slow no matter how fast the database is.

OpenACS.org has over 3000 bugs in the bugtacker, but I don't think anyone tried to view them all at once.

Collapse
3: Re: Bug Tracker Performance (response to 1)
Posted by Amruta Lakade on 04/25/08 08:39 AM
Hi,
I am getting stucked to view 25 bugs on a page.
-Amruta
Collapse
4: Re: Bug Tracker Performance (response to 1)
Posted by Dave Bauer on 04/25/08 02:40 PM
Are you using PostgreSQL or Oracle, What version?
If you are using PostgreSQL how much free RAM do you have and how many shared_buffers are configured? Also what is setting for work_mem or sort_mem (the name cahnged between 7.x and 8.x)
Collapse
5: Re: Bug Tracker Performance (response to 1)
Posted by Amruta Lakade on 04/25/08 02:50 PM
i am using postgres database.
Just now i have created my own list to display information of bugs.
But it is very much faster(shows result in 6-7 sec only) than the original list.
So i have decieded to proceed with that.

Still i want to know is it good to use new list?

I'll look at those parameters.

-Amruta

Collapse
6: Re: Bug Tracker Performance (response to 1)
Posted by Dave Bauer on 04/25/08 02:54 PM
If you can share your code that would be very helpful so we can use what you have learned to try to improve the bug tracker. Thanks.