Bug #2675

Improve sql response

Added by Sofia Papagiannaki over 9 years ago. Updated almost 9 years ago.

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

Revision 585b75e7
Added by Sofia Papagiannaki over 9 years ago

eliminate nested sql aggregations

Refs: #2675

Revision 585b75e7
Added by Sofia Papagiannaki over 9 years ago

eliminate nested sql aggregations

Refs: #2675

Revision 5f8bbf54
Added by Sofia Papagiannaki over 9 years ago

Refs: #2675

Introduce alembic

Revision 5f8bbf54
Added by Sofia Papagiannaki over 9 years ago

Refs: #2675

Introduce alembic

Revision 31e1acd3
Added by Sofia Papagiannaki over 9 years ago

Write more realistic tests

Refs: #2675

Revision 31e1acd3
Added by Sofia Papagiannaki over 9 years ago

Write more realistic tests

Refs: #2675

Revision 94243c86
Added by Sofia Papagiannaki over 9 years ago

Remove index on cluster

Refs: #2675

Revision 94243c86
Added by Sofia Papagiannaki over 9 years ago

Remove index on cluster

Refs: #2675

History

#1 Updated by Sofia Papagiannaki over 9 years ago

add index on nodes.parent

#2 Updated by Sofia Papagiannaki over 9 years ago

  • Target version changed from 0.9.8 to 0.10.0

#3 Updated by Sofia Papagiannaki over 9 years ago

  • Target version changed from 0.10.0 to 0.10.1

#4 Updated by Sofia Papagiannaki over 9 years ago

  • Status changed from New to Closed

#5 Updated by Vangelis Koukis almost 9 years ago

  • Project changed from Pithos to Synnefo
  • Target version deleted (0.10.1)

#6 Updated by Vangelis Koukis almost 9 years ago

  • Category set to Pithos

Also available in: Atom PDF