This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

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

Posted on 10-28-2018 05:00 PM
Vlad_Roman
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

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!

0 1 314
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
Aleksi_Alkio
New Member
Reply posted on --/--/---- --:-- AM

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.

0 Likes
Top Labels in this Space