Asger Blond
ab-mi at post3.tele.dk
Mon May 14 10:18:50 CDT 2012
Yes, and I didn't find any noticeable difference. Having the calculated values persisted in the table would both benefit and hurt performance - 1) benefit since no calculation is needed for the query engine, but 2) hurt since the query engine has to traverse much more data pages (remember, that the calculated field makes the table much larger). /Asger -----Oprindelig meddelelse----- Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Mark Simms Sendt: 14. maj 2012 16:28 Til: 'Access Developers discussion and problem solving' Emne: Re: [AccessD] AC2010-a pioneer with more arrows in the back... Thanks for that.....I've always been paranoid about updateable queries...seeing so many that should have been updateable but were not. In your testing of Calculated columns, did you look at retrieval speed ? Query with Calculated field vs. Table with Computed column with a where clause using that field/column ? -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com