View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000121 | HTML & PERL | Bug Report - Database | public | 2005-03-06 04:41 | 2006-02-05 00:42 |
| Reporter | egg | Assigned To | |||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Summary | 0000121: Mylist reports never complete | ||||
| Description | Some of the reports don't return results: Files which less than 5 other users have Files without length in MyList Files without md5 hash in MyList Files without sha1 hash in MyList Files with unknown source in MyList Files with incomplete resolution, codec or bitrate data in MyList I waited 15-30 minutes for each and the pages never returned... | ||||
| Additional Information | Assuming the values are stored in the same table as the CRC and ed2k hash (which do work), it doesn't make sense from a DB point of view why these take so long unless these columns do not have the proper indexes... | ||||
| Tags | No tags attached. | ||||
|
|
other than the ed2k column none of those have an index. and your results might also differ depending on the current server load. |
|
|
What's the use then for these 'random' features? |
|
|
Maybe they should be scheduled like the exports. That way they can be created at off peak times and not degrade the server further... Also, I am willing to look at performance tuning on the DB side if you are interested... |
|
|
We really need some tunning as the server is becoming more unresponsive with every day. :S |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2005-03-06 04:41 | egg | New Issue | |
| 2005-03-06 09:37 | exp | Note Added: 0000295 | |
| 2005-03-20 20:53 | DonGato | Note Added: 0000337 | |
| 2005-03-22 00:34 | egg | Note Added: 0000342 | |
| 2005-03-22 14:57 | DonGato | Note Added: 0000343 | |
| 2006-01-29 15:31 | worf | Relationship added | related to 0000259 |
| 2006-02-05 00:42 | DerIdiot | Status | new => closed |
