Changes between Version 4 and Version 5 of DatabaseCreation
- Timestamp:
- 05/04/26 11:55:59 (3 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DatabaseCreation
v4 v5 20 20 Because of this dependency, the data cannot be generated in a single step. Instead, the script simulates the application timeline, where data is created in a realistic order: 21 21 22 1. TaskRequests are created first22 1. !TaskRequests are created first 23 23 2. Offers are generated 24 24 3. One offer per task is accepted and Tasks are created … … 30 30 31 31 For simplicity and performance reasons, badge recalculation is not triggered after every change (such as each new review). Instead, it is performed at the end of each month, which significantly reduces computational overhead while still preserving realistic system behavior. 32 33 34 == Conclusion ==35 This DML script acts as a time-based simulation of the application lifecycle, ensuring that dependencies between reviews, badges, and offer pricing are respected while maintaining efficiency.
