Bug #2675
Improve sql response
Status: | Closed | Start date: | 07/16/2012 | |
---|---|---|---|---|
Priority: | Medium | Due date: | ||
Assignee: | Sofia Papagiannaki | % Done: | 0% |
|
Category: | Pithos | Spent time: | - | |
Target version: | - |
Description
SELECT DISTINCT n.path, v.serial, v.node, v.hash, v.size, v.type,
v.source, v.mtime, v.muser, v.uuid, v.checksum, v.cluster FROM nodes AS
n, versions AS v WHERE v.serial = (SELECT max(versions.serial) AS max_1
FROM versions WHERE versions.node = v.node) AND v.cluster != 2 AND
v.node IN (SELECT nodes.node FROM nodes WHERE nodes.parent = 182) AND
n.node = v.node AND n.path > E'user@fqdn/alpha' AND n.path <
E'user@fqdn/beta' ORDER BY n.path LIMIT 10000;
Associated revisions
eliminate nested sql aggregations
Refs: #2675
eliminate nested sql aggregations
Refs: #2675
Refs: #2675
Introduce alembic
Refs: #2675
Introduce alembic
Write more realistic tests
Refs: #2675
Write more realistic tests
Refs: #2675
Remove index on cluster
Refs: #2675
Remove index on cluster
Refs: #2675
History
#1 Updated by Sofia Papagiannaki about 12 years ago
add index on nodes.parent
#2 Updated by Sofia Papagiannaki about 12 years ago
- Target version changed from 0.9.8 to 0.10.0
#3 Updated by Sofia Papagiannaki about 12 years ago
- Target version changed from 0.10.0 to 0.10.1
#4 Updated by Sofia Papagiannaki about 12 years ago
- Status changed from New to Closed
#5 Updated by Vangelis Koukis over 11 years ago
- Project changed from Pithos to Synnefo
- Target version deleted (
0.10.1)
#6 Updated by Vangelis Koukis over 11 years ago
- Category set to Pithos