OpenACS / openacs-4 / packages / acs-kernel / sql / postgresql / upgrade

upgrade-5.7.0d2-5.7.0d3.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 2
Last Commit: 26 Apr
Commits this week: 0
Total Lines of Code (LoC): 81
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 24 Nov 2010
4:21 pm

victorg

- Avoiding usage of coalesce function on site_nodes table columns in WHERE clause, this was leading to usage of sequencial scans which can be expensive when having a huge amount of site_nodes. Instead we go for isolation of the case when requestion a node with a null parent ( this would be the main site node ) and we use the = operator so the planner goes for a index scan.

- Adding not null constraint to site_nodes(name)

Options
    • -0
    • +82
    ./upgrade-5.7.0d2-5.7.0d3.sql
  2. … 4 more files in changeset.