ost Performance with SetLoadFields() in Business Central
By default, Business Central loads all fields from a table record. This can hurt performance when dealing with large datasets.
💡 Use SetLoadFields() to load only the fields you need and keep your queries efficient.
✅ Only the required fields (No. and Name) are loaded.
âš¡ Reduces database load, improves performance, and avoids unnecessary overhead.
Pro Tips 🎯
Only fields included in SetLoadFields() are available.
Accessing any other field will throw a runtime error.
👉 Always list every field you plan to use.
🔴 Before (loads all fields – slower)
👉 Here, all fields from the Customer table are fetched, even if only "No." and Name are needed.
🟢 After (optimized with SetLoadFields – faster)
