Hi Jim,
Thanks for your advice. At the moment, I am testing the software without any
local optimizations.
I have galnced on the db structure and indexes and I dont think that any
more indexing will help.
I might be wrong, as I said, I have only glanced yet.
best regards
On Fri, Apr 17, 2009 at 6:23 PM, Jim4Prez <[email protected]> wrote:
> On Thu, Apr 16, 2009 at 7:49 PM, Atif Ghaffar <[email protected]>
> wrote:
> > Hi all,
> >
> > 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
> <snip>
> > 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.
>
> You should optimize the database with indexes. You can have your DBA
> do a sql trace and from there see where you need to put indexes.
>
> Jim
>
>
> ------------------------------------------------------------------------------
> 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
------------------------------------------------------------------------------
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
