[OPT-general] [ outreach-Bugs-615015 ] Document Root listing slow

[<no...@so...>]

Bugs item #615015, was opened at 2002-09-26 10:35
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=410239&aid=615015&group_id=34206

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Mark Moline (mark_moline)
Assigned to: Nobody/Anonymous (nobody)
Summary: Document Root listing slow

Initial Comment:
When users click on documents for a project and the
document root is listed, it can take up to 7 seconds
for the page to load.  The project may have only a
handful of documents that total 1 - 2 MB.

The document root listing problem occurred after a
project with 350+ MB of files was added.  It slowed
down all other projects.


The system has a total of 396+ MB of documents across 9
projects.

----------------------------------------------------------------------

>Comment By: Mark Moline (mark_moline)
Date: 2002-09-26 11:01

Message:
Logged In: YES 
user_id=595684

I added this index to the database and it seems to load in 1
second or less now.  I don't know if it is the appropriate
thing to do.

ALTER TABLE documents ADD INDEX docIndex (aproj,
obsoletedby, path);

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=410239&aid=615015&group_id=34206