Effect of subdatasheet property in Access database on the performance

Question

I have read that if a subdatasheet property in a table is Automatic,then the performance reduces. Would you please tell me the reason?

Answer 1

Hi,

if you have subdatasheet enabled, the database engine should check child table(s) to get this corresponding data, right? Otherwise, it has to check nothing.

---

Andrey V Artemyev | Saint-Petersburg, Russia
Russian blog artemyev.biztoolbox.ru