[#SAK-10454] Added indexes to improve Samigo performance

Sakai

Added indexes to improve Samigo performance

Created: 25-Jun-2007 11:52 Updated: 23-Oct-2008 08:39

Component/s:

Tests & Quizzes (Samigo), Database

Affects Version/s:

2.4.0

Fix Version/s:

2.4.x

Time Tracking:

Not Specified

Issue Links:

Relate

This issue relates to:

~~SAK-10441~~ Added indexes to imporve Samigo performance

2.4.x Status:	Resolved
2.5.x Status:	None
2.6.x Status:	None

Description

« Hide

This provides the same fix for ~~SAK-10441~~. However, because 10441 contains multiple checkins, I would like to create a separate bug for 2.4.x to make it more clear.

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

Karen Tsao - 26-Jun-2007 10:25

$ svn commit -m "~~SAK-10454~~"
Sending conversion\sakai_2_3_1-2_4_0_mysql_conversion.sql
Sending conversion\sakai_2_3_1-2_4_0_oracle_conversion.sql
Transmitting file data ..
Committed revision 31855.

[ Permlink | « Hide ]

Peter A. Knoop - 17-Jul-2007 10:37

Karen, it looks like the db conversion scripts here aren't quite right. With the release of 2.4.0 the db schema is frozen; that's to prevent confusion over different versions of the schema being out there. Any changes made after the release for the 2.4.x maintenance branch need to be done in new, separate 2.4.0 to 2.4.x scripts, rather than as modifications to the existing 2.3.1 to 2.4.0 scripts.

The 2.4.x branch manager, Andrew Poland, is coordinating work on db conversion scripts in the branch; I've added him as a Watcher to this issue. He can help you with naming your scripts, as we are uniquely identifying each 2.4.x conversion script so that folks running the maintenance branch can keep track of which ones they need to run. So please work with him to re-do this fix as a set of 2.4.0-2.4.x conversion scripts. Thanks!

[ Permlink | « Hide ]

Peter A. Knoop - 17-Jul-2007 10:40

When this issue is Resolved again, please post a note to sakai-dev letting folks know that this issue involves a db schema change so that they know they need to run the conversion scripts for their existing 2.4.0 db's to get the performance advantages for 2.4.x. Thanks.

[ Permlink | « Hide ]

Karen Tsao - 24-Jul-2007 01:30

Reverted last changes:
$ svn commit -m "~~SAK-10454~~: revert last changes" sakai_2_3_1-2_4_0_mysql_conver
sion.sql sakai_2_3_1-2_4_0_oracle_conversion.sql
Sending sakai_2_3_1-2_4_0_mysql_conversion.sql
Sending sakai_2_3_1-2_4_0_oracle_conversion.sql
Transmitting file data ..
Committed revision 33021.

Moved the changes to new scripts:
$ svn commit -m "~~SAK-10454~~"
Adding conversion\sakai_2_4_0-2_4_x_mysql_conversion_002.sql
Adding conversion\sakai_2_4_0-2_4_x_oracle_conversion_002.sql
Transmitting file data ..
Committed revision 33022.

[ Permlink | « Hide ]

Peter A. Knoop - 15-Oct-2007 10:54

Karen, it looks like the changes associated with this issue were never checked into trunk. Is this really a 2.4-specific issue, or are those changes also needed in trunk and now 2.5? Thanks.

[ Permlink | « Hide ]

Peter A. Knoop - 15-Oct-2007 11:08

See ~~SAK-10441~~ for this fix regarding trunk (2.5-era).