Hi Paul, a) Please find the file attached for the stats output.
b) We are an ASP and each domain is one project.
The project is related to mostly 3 people
1. Consultant (manager access for the project)
2. Webmaster (developer access for the project)
3. Client (reporter access for the project)
There are no sub projects but there might be project specific categories
in addition to the global categories.
c) I have not made any modification to the code but I have seen that the
list makes a cache of each project, so that might be the reason for so much
memory usage.
At the moment it is a non issue as each consultant/webmaster may have
only 10s or a couple of hundred projects.
d) I have scripted to feed the data to the mantis database.
1. get a list of all active domains and create a private project
(view_state=50)
2. Get a list of consultant, webmaster, owner and create an account with
viewer access
3. give the rights according to their role.
I dont know if it will be any worthy to make these modifications for this
specific need. I assume that this project was not designed to manage this
large volume of projects/users.
Basically I dont need much admin account functionality except just for
reporting purposes. We might anyway have to create our own reporting scripts
to customize them.
In anycase, let me know if I can help in anyway. We have been using this
software since 6 years and it is very useful.
best regards
On Fri, Apr 17, 2009 at 7:34 PM, Paul Richards <[email protected]> wrote:
> Atif,
>
> We've done a fair amount of optimising since the a3 release (only in git
> trunk atm) to try to improve performance in some areas
>
> Would you mind:
> a) can you paste the output of /admin/db_stats.php
> b) in addition, whats your rough project structure: i.e. are there a lot of
> nest subprojects in use etc?
> c) do you currently make any changes to the code to reduce the size of the
> projects box at top right - or is that a non-issue as most people can only
> see 2-3 projects
> d) is your tests on live data, or have you generated a script to generate
> the database data currently?
>
> Paul
>
> ----- Original Message -----
> From: "Atif Ghaffar" <[email protected]>
> To: [email protected]
> Sent: Friday, April 17, 2009 12:49:30 AM GMT +00:00 GMT Britain, Ireland,
> Portugal
> Subject: [mantisbt-help] installation for large volume
>
> Hi all,
>
> We have been using mantis for a few years now and are very happy with.
> We want now to give our customers the possibility to use it too to manage
> their projects. With my quick tests I see some problems.
>
> Problem: Too much memory usage, too long to load the pages, etc
> *Fatal error*: Maximum execution time of 30 seconds exceeded in *
> /var/www/mantisbt-1.2.0a3/core/helper_api.php* on line
> *300, etc
>
> Note: This happens when loggin in as administrator who has the right to see
> all accounts and projects.
>
> *Details: (version 1.2.0a3)
> I have loaded around 30K projects and 20K users.
>
> We expect this to grow 10 times more very soon.
>
> Has anyone worked with a large install like this.
>
>
>
>
>
> --
> best regards
> Atif Ghaffar
>
> ------------------------------------------------------------------------------
> Stay on top of everything new and different, both inside and around Java
> (TM) technology - register by April 22, and save $200 on the JavaOne (SM)
> conference, June 2-5, 2009, San Francisco. 300 plus technical and hands-on
> sessions. Register today. Use priority code J9JMT32. http://p.sf.net/sfu/p
> _______________________________________________ mantisbt-help mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/mantisbt-help
>
>
> ------------------------------------------------------------------------------
> Stay on top of everything new and different, both inside and
> around Java (TM) technology - register by April 22, and save
> $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
> 300 plus technical and hands-on sessions. Register today.
> Use priority code J9JMT32. http://p.sf.net/sfu/p
> _______________________________________________
> mantisbt-help mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/mantisbt-help
>
>
--
best regards
Atif Ghaffar
Title: Mantis Database Statistics
Mantis Database Statistics
mantis_bug_file_table = 1 recordsmantis_bug_history_table = 8 records
mantis_bug_monitor_table = 0 records
mantis_bug_relationship_table = 0 records
mantis_bug_table = 3 records
mantis_bug_tag_table = 0 records
mantis_bug_text_table = 3 records
mantis_bugnote_table = 0 records
mantis_bugnote_text_table = 0 records
mantis_category_table = 3 records
mantis_news_table = 0 records
mantis_plugin_table = 1 records
mantis_project_file_table = 0 records
mantis_project_table = 2001 records
mantis_project_user_list_table = 3778 records
mantis_project_version_table = 0 records
mantis_tag_table = 0 records
mantis_user_table = 1479 records
mantis_user_profile_table = 0 records
mantis_user_pref_table = 4 records
mantis_user_print_pref_table = 0 records
mantis_custom_field_project_table = 0 records
mantis_custom_field_table = 1 records
mantis_custom_field_string_table = 0 records
mantis_filters_table = 0 records
mantis_sponsorship_table = 0 records
mantis_tokens_table = 5 records
mantis_project_hierarchy_table = 0 records
mantis_config_table = 1 records
mantis_email_table = 3 records
------------------------------------------------------------------------------ Stay on top of everything new and different, both inside and around Java (TM) technology - register by April 22, and save $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. 300 plus technical and hands-on sessions. Register today. Use priority code J9JMT32. http://p.sf.net/sfu/p
_______________________________________________ mantisbt-help mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mantisbt-help
