10 Google Sheets with 1 table in each or 1 Google Sheet with 10 tables in it ?

[FaCe]

I've a Google Sheet file content ten tables with 500 rows in each table.

My Google Sheet is in streaming.

We are 3 users that access with the same Google account to the same Google Sheet.

In this case do you think is better for AppSheet to access to 1 Google Sheet with 10 tables in it or have 10 Google Sheets with 1 table in each ?

I mean in terms of performance / efficiency / syncing and so on ?

[Swoopy]

I believe packing all tables in a Google Sheets file is better because AppSheet would read the file overhead only once before look into each table inside. However, in some of my apps need to separate tables to different Google Sheets files, and I'd do this practice only if necessary.

[FaCe]

Thanks for the reply. 

Just wonder (little OT), having uniqueID(=) column, and existing data (so i need to create manually uniqueID for that existing data) there are issue using the same uniqueID numbers in the various columns of each table in the same sheet ? Or uniqueID are - as i suppose - table related (and not sheet related) ?

[Swoopy]

are there issues using the same uniqueID numbers in the various columns of each table in the same sheet ?   

In my practice, I've never used and suggested people to use auto-ID as table's (primary) key. Because it give no meaning to describe each row's fingerprint.

Each table has its purpose to exist(i.e for products, for orders, for staffs, etc.), also each row must have identity (i.e product ID, order number, staff ID, etc.) that differentiate itself from other rows in a table. This (row's fingerprint) may be a column or a combination of columns(i.e order-products,  staff-paychecks, etc.), and AppSheet allows you to set table's key either way.

If a key is composed from multiple columns, there will be a new computed column created automatically by AppSheet. The key prevents duplication of the picked column(s) in table.

uniqueID are - as i suppose - table related (and not sheet related) ? 

The auto-IDs output from AppSheet's UNIQUEID() are just random text and wouldn't depend on either table or sheet.