Skip to main content
P
prachit0003
September 9, 2023
Question

Database

  • September 9, 2023
  • 12 replies
  • 0 views

I'm using view to get different columns from two tables and using that view to generate the report in excel. 

So my question is : After the 5-6 years the data will be large inside the view which I'm using currently, so is there any alternate way to get the data faster as compared to view in Appian.

Thank you.

    12 replies

    mathieud0001
    mathieud0001
    Brainy
    September 9, 2023

    Depends on what you are trying to do.

    Is this an actual report you are generating or are you just doing an export of the data? It you're doing an export, you can only export 50K rows.

    P
    prachit0003Author
    September 9, 2023

    Actually I just gave the overview of my project. My exact question is after 5-6 years the data will be larger in the view so fetching particular data is time taking, then what should I use instead of view to get the data faster.

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    September 9, 2023

    Sorry, but your "overview" misses the most important numbers:

    - Number of rows in both tables as of now

    - Number of rows added per year in both tables

    Then some questions:

    - How often do you run that report?

    - Does a user need to wait or is this generated in the background?

    - Did you consider synced records?

    - Did you already implement database optimisation? Indexing, foreign keys etc...

    Terms & ConditionsAccessibility statement