before starting as described here
, we have factory , then branches will sale its products
the software witch i review , having no links between the branches and the factory
each one have separate database , as they said to keep the operation fast & quickly
if they do linking them , the transactions will be slowly , moreover while too customers in the branches .
to do the transactions between the branches , e.g : ordering items from the factory then receiving it automatically , they have something like patch file to sent text files between each other
then some process should be done to complete receiving then posting that transactions
what do you advice ?
1-oracle or mysql ? note i never work mysql before
2-is that strategy (sending text files between the factory & branches ) is right ?
or better do linking between them , ( via internet ) ?