I am building a grading system for students and got unexpected
performance problems. I am using composite key for marks, which refer
to students and subjects.
When I am creating a mark (for student_1 and subject_1), unnecessary
select operations are performed (select all marks for
On Nov 19, 2007, at 6:22 AM, Anton V. Belyaev wrote:
Setting the relation to be lazy=dynamic really eliminated
unnecessary selects when creating Mark. Making a default relation a
bit dynamic is a great idea!
There is problem when relation is both lazy=dynamic and
cascade=all,
On Nov 18, 2007, at 4:54 PM, Anton V. Belyaev wrote:
Hello all,
I am building a grading system for students and got unexpected
performance problems. I am using composite key for marks, which refer
to students and subjects.
When I am creating a mark (for student_1 and subject_1),