Hi everyone,
I’m experiencing a significant performance issue with a master-detail form and would appreciate any guidance.
The Problem: When the master form loads, the detail section takes 5-13 seconds to display approximately 50 records from a database containing 250,000 total records.
What I’ve Tested:
- Running the same SQL query directly in the database: 0.1 seconds ✓
- Loading the same query in a simple grid application: Fast ✓
- Loading it in the master-detail form: 5-13 seconds ✗
Observations:
- The SQL query itself is properly optimized
- The issue appears to be specific to the master-detail form implementation
- I’ve noticed others reporting similar issues in the forum, but haven’t found any solutions yet
Can anyone help ?