Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Thu Jun 19 17:33:40 CDT 2008
Gustav: Legacy code - I don't want to mess with it unless I have to. It runs in a reasonable amount of time now. So there's no priority on optimizing it. IF it's necessary - I'm a big fan of DAO myself. It's a scheduling program so lots of date manipulation. Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Thursday, June 19, 2008 2:33 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Timer Event Hi Rocky That's a lot. Are you running many queries? Perhaps you could speed up the code replacing SQL with DAO? I've done that myself for code than ran nicely with the test data but ran slowly with real life data volumes. /gustav >>> rockysmolin at bchacc.com 19-06-2008 21:05 >>> Yeah once per second is probably adequate. The calculations, however, is about 2000 lines. So that's a lot of DoEvents. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG. Version: 8.0.100 / Virus Database: 270.4.0/1509 - Release Date: 19/6/2008 08:00