Intel Software to boost Access' performance

[jimfortune]

I receive occasional notices from the Intel Software Network. I got
one concerning the Intel Math Kernal Library 8.0. The blurb is at:

http://www.intel.com/cd/software/pro.../mkl/index.htm

Has anyone used this Intel specific software in an attempt to boost
Access' performance? If so, how much of an improvement did you get?
Thanks for any and all information regarding this software.

James A. Fortune

[Larry Linson]

<ji********@compumarc.com> wrote

I receive occasional notices from the Intel Software Network. I got
one concerning the Intel Math Kernal Library 8.0. The blurb is at:

http://www.intel.com/cd/software/pro.../mkl/index.htm
Has anyone used this Intel specific software in an attempt to boost
Access' performance? If so, how much of an improvement did you get?
Thanks for any and all information regarding this software.

I have not seen any "math-intensive" applications done in Access --
particularly the kind of calculations described as being addressed by this
library. It has, as far as I can remember, always been possible to create
external procedures/subroutines that compile to machine code for math
functions and call them from Access, but I've never actually seen one used
with an Access app. -- on occasion, with VB (but then VB5 and VB6,
themselves, compiled to machine code.

Access' VBA, on the other hand, can be "compiled" but only to a "tokenized
state", not to machine code. It is, therefore, interpreted, not executed as
machine code... in actuality, it triggers many calls to internal procedures,
written in C++ IIRC.

That's not to say that there aren't a few Access apps of that kind, but I
suspect "few" would be the operative word.

I, too, would be (at least mildly) interested to know of someone who had an
application so math-intensive that it would benefit from the library and
what type of application it is.

Larry Linson
Microsoft Access MVP

[jimfortune]

Larry Linson wrote:

<ji********@compumarc.com> wrote

>I receive occasional notices from the Intel Software Network. I got
> one concerning the Intel Math Kernal Library 8.0. The blurb is at:
>
>

http://www.intel.com/cd/software/pro.../mkl/index.htm

>
> Has anyone used this Intel specific software in an attempt to boost
> Access' performance? If so, how much of an improvement did you get?
> Thanks for any and all information regarding this software.

I have not seen any "math-intensive" applications done in Access --
particularly the kind of calculations described as being addressed by this
library. It has, as far as I can remember, always been possible to create
external procedures/subroutines that compile to machine code for math
functions and call them from Access, but I've never actually seen one used
with an Access app. -- on occasion, with VB (but then VB5 and VB6,
themselves, compiled to machine code.

Access' VBA, on the other hand, can be "compiled" but only to a "tokenized
state", not to machine code. It is, therefore, interpreted, not executed as
machine code... in actuality, it triggers many calls to internal procedures,
written in C++ IIRC.

That's not to say that there aren't a few Access apps of that kind, but I
suspect "few" would be the operative word.

I, too, would be (at least mildly) interested to know of someone who had an
application so math-intensive that it would benefit from the library and
what type of application it is.

Larry Linson
Microsoft Access MVP

Larry,

Thanks for your input. The blurb seemed to indicate that benefits
could be gained even if the application is not "math-intensive." I'm
thinking that some of the calls to C++ may run faster with the library
so I'm particularly interested in speed gains for Access apps in
general. If I buy the software I will do some performance tests.

James A. Fortune

[jimfortune]

ji********@compumarc.com wrote:

Thanks for your input. The blurb seemed to indicate that benefits
could be gained even if the application is not "math-intensive." I'm
thinking that some of the calls to C++ may run faster with the library
so I'm particularly interested in speed gains for Access apps in
general. If I buy the software I will do some performance tests.

James A. Fortune
This seems to be closer to what I am looking for:

http://www.intel.com/cd/software/pro...ipp/238679.htm

The errors people talk about it their 'chat' area make the products
look a littly shaky. It looks like it's going to be more helpful for
..NET and Visual Studio since I don't want to recompile too many dlls.
I use compression and strings a lot. I'll still look for ways to use
it to make Access faster.

James A. Fortune
From A97 'Option Compare' help: If you use a case-insensitive string

comparison method, the Bookmark property may point you to the wrong
record.

[Lyle Fairfield]

ji********@compumarc.com wrote:

From A97 'Option Compare' help: If you use a case-insensitive string
comparison method, the Bookmark property may point you to the wrong
record.

And?

--
Lyle Fairfield

[jimfortune]

Lyle Fairfield wrote:

ji********@compumarc.com wrote:

From A97 'Option Compare' help: If you use a case-insensitive string
comparison method, the Bookmark property may point you to the wrong
record.
And?

--
Lyle Fairfield

You need more info :-)? I don't want anybody pointing their Bookmarks
where they shouldn't. It's an easy point to miss.
From A97 'Option Compare' help:

If you are using the Bookmark property of a Recordset object, you must
include an Option Compare Binary statement in the Declarations section
of the module. The setting and return value for the Bookmark property
is a Variant array of Byte data. If you use a case-insensitive string
comparison method, the Bookmark property may point you to the wrong
record.

James A. Fortune