View Issue Details

IDProjectCategoryView StatusLast Update
0002148SOGoBackend Generalpublic2013-01-11 17:05
Reportergeepie Assigned To 
PrioritynormalSeverityfeatureReproducibilityalways
Status closedResolutionwon't fix 
Product Version2.0.3a 
Summary0002148: PostgreSQL Optimisation: Begin/Commit
Description

Begin/Commit with an one line SQL statement is not needed.

Rollback on one line SELECT line is not need too.

Additional Information

From the detailled postgresql logs:
Dec 16 23:18:32 desktop postgres[1245]: [15-1] u=_sogo,db=mail LOG: statement: BEGIN TRANSACTION
Dec 16 23:18:32 desktop postgres[1245]: [16-1] u=_sogo,db=mail LOG: statement: UPDATE sogo_user_profile SET c_settings = E'{"Mail": {"DragHandleHorizontal": "192", "SortingState": ["date", "0"], "ExpandedFolders": "[\\"\\/0\\"]", "DragHandleVertical": "218", "ColumnsState": {"subjectHeader": "36", "priorityHeader": "5", "fromHeader": "25", "dateHeader": "18"}, "DelegateFrom": []}, "Contacts": {"DragHandleHorizontal": "201", "DragHandleVertical": "194"}, "CalendarDefaultFilter": "view_next7", "Calendar": {"FolderColors": {}, "View": "monthview", "DragHandleVertical": "134", "FreeBusyExclusions": {}, "SelectedList": "eventsListView"}}' WHERE c_uid = 'jg@rilk.com'
Dec 16 23:18:32 desktop postgres[1245]: [17-1] u=_sogo,db=mail LOG: statement: COMMIT TRANSACTION

Dec 16 23:13:32 desktop postgres[26838]: [34-1] u=_sogo,db=mail LOG: statement: BEGIN TRANSACTION
Dec 16 23:13:32 desktop postgres[26838]: [35-1] u=_sogo,db=mail LOG: statement: SELECT t1.c_creationdate, t1.c_id, t1.c_lastseen, t1.c_value FROM sogo_sessions_folder t1 WHERE t1.c_id='ij1cVjElK9Bi29bennzuxw=='
Dec 16 23:13:32 desktop postgres[26838]: [36-1] u=_sogo,db=mail LOG: statement: ROLLBACK TRANSACTION

TagsNo tags attached.

Activities

ludovic

ludovic

2013-01-11 17:05

administrator   ~0005139

This is don't automatically by sope-gdl and we have no plans on changing this.

Issue History

Date Modified Username Field Change
2012-12-16 22:30 geepie New Issue
2013-01-11 17:05 ludovic Note Added: 0005139
2013-01-11 17:05 ludovic Status new => closed
2013-01-11 17:05 ludovic Resolution open => won't fix