Hi,
Thanks for your input - i have done some tests now:
1. I have created all products, features and variants through xmlrpc (3M
records, 12h..)
2. Exported ofbiz-xml-data
3. pg_dumped
4. imported xml-data on a clean install: ~40m
5. imported pg_dump of the same data: ~7m
I think we will choose ofbiz-xml-data, its fast enough!
Regards
Greg
On 08/08/2012 01:45 PM, Nicolas Malin wrote:
> Hi,
>
> Prepare ofbiz xml-data with ofbiz system or ftl or xslt or other etl.
> Desactivate your eeca on spot server and load your files.
>
> Nicolas
>
> Le 08/08/2012 10:52, greg jocher a écrit :
>> Hi all
>>
>> We are working on a data migration to migrate multiple stores.
>> Each store uses all or a part of the ~150 virtual products.
>> Each virtual has between 10 and 1k variants (combination of 2 to 6
>> features...).
>> This migration has to be done in less than 5 hours.
>>
>> What do you think is the fastest way to migrate these products and
>> its 300k customers? pure sql-scripts? postgres datafiles?
>> ofbiz-xml-data?
>>
>> Btw: The production installation will not be inhouse - we currently
>> use xmlrpc for the migration, but it is just to slow:
>> I have written the product part and it is running since more than 8
>> hours. DB, Ofbiz, Migration all on the same dev-machine (16G mem, amd
>> phenom x6, SSD, Postgres on Raid10) - yes, xmlrpc is really to slow
>> for bulk migration..
>>
>> Regards
>> Greg
>
>
Locked
