Here is my intallation, 1 website (1 domain) with 2 store and each store view. "Use Flat Catalog Category" and "Use Flat Catalog Product" are enabled.
In my database, I therefore following tables: catalog_category_flat_store_1 catalog_category_flat_store_2 catalog_product_flat_1 catalog_product_flat_2
In each table "catalog_category_flat_store" I have the corresponding categories for each store, store 1: Categories of my store 1 & 2 store: the category of my store 2 No worries..
But in my table "catalog_product_flat" I have all my products present in both tables, they are not dispatched in one or other of the two store based on their membership. Is this normal or am I missing a setting somewhere? Suddenly it increases the size of the database.
Thank you in advance