Forum OpenACS Q&A: Response to Would copy speed PG installs of reference data?
2: Response to Would copy speed PG installs of reference data? (response to 1)
Posted by Don Baccus on 01/31/02 04:11 AM
The "insert" format's portable so we don't need to massage the data twice when we update it. For instance during the so-called "energy crisis" last summer there was talk in California of going to double-daylight savings time. That would've required new files to be generated (and screwed up all timezone data in the world which uses Los Angeles as a surrogate for the Pacific Timezone!)
So we're trading off speed of loading for easier maintainability and of course an easier porting task if we adopt a third RDBMS in the future.