OpenACS / openacs-4 / packages / chat / www

index-postgresql.xql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 7
Last Commit: 05 Apr
Commits this week: 0
Total Lines of Code (LoC): 31
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 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 06 Jun 2023
2:07 pm

antoniop

Make sure only one tuple per room is returned

Options
    • -7
    • +10
    ./index-postgresql.xql
Tuesday 02 May 2023
10:00 am

gustafn

Improved SQL query significantly by using "acs_permission.permission_p_recursive_array"

Before, a sample query used 300K buffers, now it is down to 2.6 buffers.

Under bad conditions, the old query used 2s or more.

Options
    • -0
    • +18
    ./index-postgresql.xql
  2. … 2 more files in changeset.
Friday 15 Mar 2019
6:30 pm

antoniop

Reduce divergency between oracle and postgres codebase and make the query less awkward

Options
    • -31
    • +0
    ./index-postgresql.xql
  2. … 2 more files in changeset.
Monday 27 Apr 2015
9:12 am

gustafn

- improve performance of index page in postgres for large sites from around 10 secs to 120 ms by moving function calls out of sql aggregation

Options
    • -11
    • +14
    ./index-postgresql.xql
  2. … 1 more file in changeset.
Monday 19 Nov 2007
2:14 am

donb

Rolled back HEAD to the version on the 5.3 branch

Options
    • -26
    • +0
    ./index-postgresql.xql
  2. … 110 more files in changeset.
Sunday 24 Jun 2007
5:21 pm

maltes

Fixing a lot of bad programming techniques and try to get .LRN out of the package, in vain...

Options
    • -1
    • +1
    ./index-postgresql.xql
  2. … 8 more files in changeset.
Thursday 07 Jun 2007
11:14 am

pablom

"New version of the package"

Options
    • -0
    • +26
    ./index-postgresql.xql
  2. … 88 more files in changeset.
Saturday 24 Jun 2006
4:23 pm

gustafn

brought chat in cvs head to the same level as in oacs-5-2, normalized comparisons and expr (using eq etc.)

Options
    • -0
    • +2
    ./index-postgresql.xql
  2. … 81 more files in changeset.
Thursday 30 Mar 2006
11:15 am

palberer

merge changes from the ajax package with the java version

Options
    • -0
    • +2
    ./index-postgresql.xql
  2. … 53 more files in changeset.
Tuesday 14 Mar 2006
1:16 pm

emmar

Valencia chat package. Provides support for postgresql and few enhancements like user search.

Options
    • -0
    • +26
    ./index-postgresql.xql
  2. … 90 more files in changeset.