Thanks Atif,
I've tested up till about 4000 projects (with some level of subprojects) on my
test data sets, so this is slightly larger.
If you are just evaluating, it might be worth looking at git trunk. On top of
that I've got a couple of development branches at the moment that are works in
progress that might have a knock-on effect of optimising some things (
http://git.mantisforge.org/w/mantisbt/paul.git - two branches - one that starts
to change the way we handle dates, and the other BugData objects)
In terms of your data set, I think you might currently be going to hit a couple
of issues:
a) we kick off a call to project_cache_all (which does a SELECT * FROM
mantis_project_table) for any page hit
--> Reason: that's 'quicker' as the dropdown box to select projects generally
requires all projects to be loaded, but for this case...
b) The project select box - I assume currently only shows 2-3 projects per
user?
c) Filters (view issues page) - I believe the AJAX dropdown selectors to search
by reporters includes *ALL* users (i.e. 17,000). Someone has submitted a patch
into www.mantisbt.org/bugs suggesting that we limit the reporters to reporters
linked to the projects a user is related to, or similar.
At the moment, the things i'm aware of that i'd like to try to optimise, but
haven't done are:
a) large number of viewable projects
b) subprojects hierachies
c) generated emails with large numbers of linked people.
I'd be interested to know if the latest development code also shows out of
memory errors assuming your just testing this.
Out of interest, given you are running php 5, what is your php memory limit set
to? I know that php group changed the default limit from 8MB to 128MB as php5
itself requires more ram than php4.
Paul
----- Original Message -----
From: "Atif Ghaffar" <[email protected]>
To: "Help with Mantis" <[email protected]>
Sent: Friday, April 17, 2009 11:23:45 PM GMT +00:00 GMT Britain, Ireland,
Portugal
Subject: Re: [mantisbt-help] installation for large volume
Here are the new stats after loading the data again.
Mantis Database Statistics
mantis_bug_file_table = 1 records
mantis_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 = 26682 records
mantis_project_user_list_table = 50743 records
mantis_project_version_table = 0 records
mantis_tag_table = 0 records
mantis_user_table = 17051 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 = 3 records
mantis_project_hierarchy_table = 0 records
mantis_config_table = 1 records
mantis_email_table = 3 records
On Sat, Apr 18, 2009 at 12:03 AM, Atif Ghaffar < [email protected] >
wrote:
On Sat, Apr 18, 2009 at 12:01 AM, Atif Ghaffar < [email protected] >
wrote:
Hi Paul,
a) Please find the file attached for the stats output.
PS: This report is after deleteing all projects/users and then loading just a
few thousand records.
If you want that I fully load the database and provide you the report, please
ask.
--
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
