Many columns in one table or many tables with a few columns?

[gvalero]

@nathanaelb

I recall David saying in the forum that Glide Tables will handle as many columns as you want. From a performance perspective, I don’t think 300 columns would affect performance negatively. So perhaps you don’t need to split up you tables.

Good point, I don’t know the Glide’s internal architecture (backend) but most cases in other software, the more columns a table has, the slower its performance. Take a look at my example using a Google Sheet as API to understand what I try to explain.

In my tests, I had 45k rows with 8 columns and its performance to reply an API request was 4-6 secs (a good number for me!). Later, when I tested using 35 columns with the same 45k rows, the replies lasted 9-12 secs (I didn’t like the number anymore )

I don’t want to imagine, how long a reply would last if the table (GS) had 100 columns or 300!!

Saludos!