[ic] Identify cause of slowness loading returns.html

DB db at m-and-d.com
Tue Apr 26 13:22:36 UTC 2011


> On 26/04/11 08:20, DB wrote:
>> Hmm - it seems that when I comment out these lines, things go quite fast:
>> 
>>  [seti export][tag export transactions transactions.txt][/tag][/seti]
>>  [seti export][tag export orderline orderline.txt][/tag][/seti]
>> 
>> Is there any reason to keep the export commands in place if I'm using mysql?
>> These txt files have always been a bit of a mystery to me.
> 
> That's fine, but I recommend that you set the following in your catalog.cfg:
> NoImportExternal Yes
> 
> This will prevent Interchange from trying to dump your sql tables and 
> re-import them from the corresponding txt files which would end up being 
> old data for you.
> 
> Also I recommend that you use mysqldump from a cron job to make a backup 
> of your db (if you're not doing so already), as you cannot use those txt 
> files as a backup anymore.
> 
> I generally recommend that people set this regardless as a dump and 
> import from txt files can screw up customizations you've made to your 
> sql tables (not to mention the possibility of importing old data).
> 
> 
> Peter


Thanks for the tip. I already have a line like this:

"NoImport  inventory products userdb"

Should I add

"NoImportExternal Yes"

also or instead?

DB



More information about the interchange-users mailing list