寻找除xml之外的更好的解决方案

Question

I have currently 100 stores each with separate database. I want to develop a web portal which will display all 100 stores and if someone wants to search he will get the products from 100 stores on this portal rather going to different store's website. i was using xml for this purpose but it taking too long to parse xml file and filter the records of each store according to search keyword. i was generating xml when any store add new or edit product record. And on the portal website i was just parsing these generated xml (using PHP) files.

Please guide me if there is any better solution other than xml parsing. Let me clear one thing that all these stores and portal are hosted on same server and using subdomain for each store.

Thanks in advance.

Answer 1

Use a single database. Distinguish between stores with a store table that you reference with a foreign key column in any table where it is relevant (which is likely only going to be the stock table).