Problems with CSV download

AppSheet AppSheet Q&A
1

Dear Community:
I have a table of 14,000 records (simple without virtual columns, or complicated formulas) and a slice that makes a selection of records that can later be downloaded as CSV.

The problem is that downloading 1 or 50 records takes the same time as downloading 14,000 records, that is, between 60 and 90 seconds. Obviously our client does not accept having to wait so long every time he selects a few records.

When we have presented the case to Support, they have told us that it is 1 or 14,000 (the total data). AppSheet works with all the data and therefore takes so long.

I think it’s a point for Google Cloud engineers to work on fixing.

Anyone have any other ideas?

2

Hi. you can try create a filter with the new information that this option download the few records?

example:
I have 9500 records of Inbond Exported

3X_6_0_603f0f414e81dad21778f40c3efcb79d45396664.png
3X_6_0_603f0f414e81dad21778f40c3efcb79d45396664.png1097Ă—853 91.7 KB

i used a filter only with the last 3 days of records. and the

3X_4_3_439e61173870b4dbd3f3dd9080ac845c6334b9d9.jpeg
3X_4_3_439e61173870b4dbd3f3dd9080ac845c6334b9d9.jpeg1092Ă—846 192 KB

3X_5_e_5ee57f082b3ae8e2b934048d3f3e1a6ae3972706.png

3X_0_6_0680f4231a13a4924ebe1dcb7b4df1edfc962971.png
3X_0_6_0680f4231a13a4924ebe1dcb7b4df1edfc962971.png1694Ă—308 14.3 KB

3

Thanks Daniel, but that’s not the solution. I have done tests and I have filtered a single record, AppSheet still takes more than a minute to download CSV and this because the database has more than 15 thousand records.

4

@Phil Any Insights here?

5

How do you currently apply filtering ? Slice?

6

Yes, Slice.

7

I m not testing yet, but filter the row, using LINKTOFILTEREDVIEW() expression. Then from that filtered view, invoke the action to export to CSV to see the difference. That s my one of suggestion.

2 Likes
8

Hi Tsuji:
Although the answer of AppSheet has been that this time cannot be decreased, it would be interesting to test your suggestion. Could you elaborate on where the LINKTOFILTERVIEW () expression would go. Thank you.

9

It depends on how your data schema stands as well as your business requirement in terms of how to filtering the rows.

For testing purpose, for instance, if you have column like “Category” or “Grouping” stuffs for each row, then create inline action for this table and column somewhere.

The action is go to other view in this app and expression is something like

LINKTOFILTEREDVIEW(“View Name”, [Category]=[_thisrow].[Category])

Once you jump to the filtered view, then hit the action to export to CSV to see how it goes.

Keep your stop-watch ready!

1 Like
10

ok, sorry for my English. My Solution is Create the Security filter since Data

3X_c_b_cb140bd672a48e092588def6162420d559082a56.png
3X_c_b_cb140bd672a48e092588def6162420d559082a56.png1240Ă—608 54.4 KB

to do since my data base copy the original Sheet and rename with the filter name:

3X_d_f_dfc7377600b9407e916fafe21b05a2983abe8b80.png
3X_d_f_dfc7377600b9407e916fafe21b05a2983abe8b80.png822Ă—137 12.9 KB

both sheets contains same information but the copy apply the filter, this makes the database already filtered to appsheet and is very small

11

Hi Daniel, Thank you very much for your answer. I did tests and got:

  • When the table contains only 1 record, the download takes: 4 sec.
  • When the table has 11 thousand records, and 1 record (slice) is selected, the download takes 30 sec.
  • When the table has 11 thousand records, and all the records (slice) are selected, the download takes 45 sec.
    There is a big difference between 4 and 30 seconds. It would be nice if AppSheet only reads the selected records in the slice so that the download takes less time, but now we know that it is not. Thanks a lot for your help.
12

tsuji_koichi:

Once you jump to the filtered view, then hit the action to export to CSV to see how it goes.> > Keep your stop-watch ready!

Thanks Tsuji.