His ‘great and laborious undertaking’ was finally completed after 19 years, by which time the Painted Hall was felt to be far too grand for its original purpose