Menu ▾ ▴

#78 Document Root listing slow

closed-accepted
nobody
None
5
2002-10-01
2002-09-26
Mark Moline
No

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.

Discussion

  • Mark Moline

    Mark Moline - 2002-09-26

    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);

     

  • Bogdan Stancescu

    Bogdan Stancescu - 2002-10-01

    Logged In: YES
    user_id=341406

    Yes it is. Will be included in the next release - thanks!

     

  • Bogdan Stancescu

    Bogdan Stancescu - 2002-10-01
    • status: open --> closed-accepted
     

Log in to post a comment.