Jim Dettman
jimdettman at verizon.net
Mon Feb 19 07:41:07 CST 2007
Jim, <<By checking the local references a program can then adapt to its' current surroundings; but this requires a late-binding design.>> How so? If your dimming something as an object, you using late binding. I don't know of anyway of changing from late to early without re-compiling the program. And if you use late binding, your carrying the performance hit all the time. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Friday, February 16, 2007 2:36 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Missing references Hi Jim: The main reason for using late-binding is that an application developer does not know what version of Word or Excel is on the clients' computer until the application is run. By checking the local references a program can then adapt to its' current surroundings; but this requires a late-binding design. Just a comment Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Friday, February 16, 2007 10:54 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Missing references <<Is this verifiable,>> Pretty much yes. As I said to John, it depends on the mix of operations that you are performing. But in all cases it is faster without a doubt. It's just a matter of how much. From past timings that I did, I found as a general rule of thumb that it was a 10% - 15% overall difference in speed. <<Is this a thumbnail calculation or can you supply concrete arithmetical evidence?>> I did this years ago and have always used early binding as a result whenever possible. If I use late binding, I put it in the spec and note that it is a performance drain. So I'll use late if I have to, but I don't like it<g> Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of artful at rogers.com Sent: Friday, February 16, 2007 10:21 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Missing references Is this verifiable, Jim? I haven't ever used late-binding, which I admit has caused various installation issues, but I am curious. Is this a thumbnail calculation or can you supply concrete arithmetical evidence? A. ----- Original Message ---- From: Jim Dettman <jimdettman at verizon.net> To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> Sent: Friday, February 16, 2007 9:49:44 AM Subject: Re: [AccessD] Missing references Bryan, One thing you didn't mention is the performance hit; late binding costs you 10-15% for every operation perform. Jim. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com