[
http://mifosforge.jira.com/browse/MIFOS-4043?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=61164#action_61164
]
jbrewster commented on MIFOS-4043:
----------------------------------
This upgrade is adding question groups. Attached the sql for this upgrade.
Can queries be optimized?
> Performance issue with DB upgrade 1279140399
> --------------------------------------------
>
> Key: MIFOS-4043
> URL: http://mifosforge.jira.com/browse/MIFOS-4043
> Project: mifos
> Issue Type: Bug
> Components: Database
> Affects Versions: Release E
> Reporter: jbrewster
> Priority: Critical
> Attachments: sdemodata.zip, upgrade1279140399.sql
>
>
> Database upgrade with timestamp 1279140399 taking over 25 minutes on my local
> machine when upgrading a small data set. (data set attached). Reminded me
> that Sungard had the same issue during an upgrade test last week (different
> data)
> - Why is this taking so long?
> - Can we show progress for long (+1 minute) upgrades?
> - Will this upgrade be so slow that users won't have time to upgrade?
> Attaching data set used for upgrade. On console I see:
> applying upgrade with timestamp: 1277565300
> applying upgrade with timestamp: 1277565388
> applying upgrade with timestamp: 1278542119
> applying upgrade with timestamp: 1278542138
> applying upgrade with timestamp: 1278542152
> applying upgrade with timestamp: 1278542171
> applying upgrade with timestamp: 1279140399 <------- waiting for this upgrade
>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
