Hello guys,
I have a big database that I display on a repeating group.
I import a lot of data in this database, so it could exceed 100k+ rows at some points.
I fill this databse from multiple sources, and I wonder if it is best to put everything in the same database or if it is better to put it in 2+ databases depending on the source (even if it adds a lot of complexity).
From a WU usage and speed perspective, which option do you think is the best?
Thanks
Hello @pol3second Welcome to the community!
In these scenarios I tend to think rather on how often processing the entire list would be needed.
If the answer is a quick yes … then depending on budget there is my answer. Bubble can handle lots of data and processing (even somewhat fast turnarounds) … but at a cost.
As for complex processing and a super-fast need to get a result I would keep the data package outside for processing.
When dealing with a synched dB you have to make one of them be the owner of truth. Else … be prepared to have an unreliable setup.
Hope that the above makes sense as there may not be a straightforward answer.
