Feature #118
Zip Codes Load fails on slow machines
| Status: | Closed | Start: | 05/25/2009 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | 06/30/2009 | |
| Assigned to: | tshif | % Done: | 100% |
|
| Category: | - | |||
| Target version: | Weather by ZIP Code - v 1.1.5 | Estimated time: | 1.00 hour |
Description
Zip Codes Load fails on slow machines. Assess splitting the load into two separate scripts.
History
Updated by tshif over 2 years ago
- Estimated time set to 1.00
Updated by tshif over 2 years ago
- Tracker changed from Bug to Feature
Updated by bsau over 2 years ago
- Due date set to 06/08/2009
- Status changed from New to Assigned
- Assigned to changed from tshif to bsau
- % Done changed from 0 to 10
I will split the very large initial data load into two pieces. Well do the first 22 thousand inserts in the install sql file, and the rest in the install.php file. This will make it possible to have a progress message on the screen a little earlier in the installation as well.
Updated by bsau over 2 years ago
- Status changed from Assigned to Resolved
- % Done changed from 10 to 70
I moved the initial DB load starting with record 21,000 to the install.php file, and left several commit breaks in it to reduce the possibility of failure due to trying to load such a large DB at one time.
Updated by bsau over 2 years ago
Moving some of the bulk load to install.php proved a royal pain. Instead, Ive broken up the initial load with a commit every 500 records or so. This is undergoing some testing here on slower machines to see how it performs.
Updated by bsau over 2 years ago
- Assigned to changed from bsau to tshif
- % Done changed from 70 to 90
Test new Initial ZIP load strategy - load is very fast, even on previously troubled machines.
Awaiting formal software test before release.
Updated by tshif over 2 years ago
- Status changed from Resolved to Feedback
This test good for me on a machine it used to fail on. Would someone else please check it out of the repo, and try a fresh install be fore we consider this case closed?
Updated by tshif over 2 years ago
- Due date changed from 06/08/2009 to 06/30/2009
- Status changed from Feedback to Closed
- % Done changed from 90 to 100
Updated by tshif over 2 years ago
- Target version changed from Weather by ZIP Code - Future Releases to Weather by ZIP Code - v 1.1.5