We have some projects which are running many scripts with many different transactions. This gives that the results/analysis-files are becoming huge and breaks the limit for Accessdatabases. This is overcome by switching to SQLite (or SQL-server). And then Analysing also takes very long time.
Is there anyting other that can be done, other than lower the number of different transactions in each script?
Both for loweirng the datasize and the time taken for Analysis.
For example will shortening transaction names help?
Please mark post as solved if your problems or questions is/are resolved.
If this post was valuable to you, please consider kudo it.