You are viewing limited content. For full access, please sign in.

Question

Question

laserfiche cloud what happens after look up tables reachs 10k

Laserfiche Cloud
Updated December 3, 2020
asked on December 3, 2020

does it just prevent you from adding more data or is there some type of FILO system set up for these look up tables? 

 

Im thinking about implementing my own query logic for removing old rows of Main look up when it hits 10k but idk let me know what you guys think of this simple pseudo design:

run rules as top down of workflow 

1. run rule for select all key and date sorted by date.

2. check if key max is 10k 

3. logic for key for oldest date. 

4. run rule for removing by key

return to previous workflow or just be done. 

 

*** KEEP in mind the limitations when creating the iteration logic removing values from main look up table. 

0 0

Replies

replied on December 3, 2020

There is no FILO system, when lookup table exceeds the limit of 10K, insert queries will throw limit errors.

I think your solution looks good. If the limitation for iteration is a concern,  instead of deleting the rows in an iteration you can use a query to delete rows from oldest date to a given date (you can use the date calculator based on oldest date, e.g., from "oldest date" to "oldest date + 1 day"):

1. run rule for select all key and date sorted by date.

2. check if key max is 10k 

3. logic for key for oldest date. 

4. Create a date token calculator based on oldest date (with adding day or hours to oldest date)

5. run rule for removing keys between given dates

0 0
replied on December 3, 2020

ohh okay so you are saying that i should do a delete row by two date values .. interesting. ill get back to you if that is how I implement things. 

 

.. this whole limitation thing for cloud .. makes cloud more fun but im out here doing calculations of possible iteration counts .. i think im going to create a javascript function that tells me the maximum possible iterations before it hits 10k but idk i havent inspected cloud workflow designer. Maybe a find iteration for each activity but idk .. if anyone has tried this and has a tool let me know :) 

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...