Hi, I want to know if i create each of my ta...

references
(Vlad Roman) #1

Hi,

I want to know if i create each of my tables in separate Worksheets rather than in Sheets inside one Worksheet it will affect the speed of my queries? Almost all of my tables will be referenced.

I want to do like so because i know that 1 worksheet can hold only 2 million cells and some of my tables will handle a lot of data.

What is the best approach?

Thank you!

(Aleksi Alkio) #2

I believe you should start to use SQL right from the beginning. You could build the app with spreadsheets, but the sync will increase lot earlier than that 2M limit. You should also think about this case if it would be possible to create this with more than just one big app.