>>Very nice. Care to share any details of what you changed?
>
>Offloading of SQL Server transactions into memory management for whatever is related to the data dictionary. So, instead of querying the data dictionary on request for a bunch of information, I simply load it all into memory at startup.
>
>As mentioned in another thread in the .NET forum, this eats up much more memory but so much more power the application will benefit from.
>
>So, it goes like this:
>
>
>oApp.Tables(MyTable).Name
>oApp.Tables(MyTable).Fields(MyField).Mandatory
>
>
>...and so on.
So far so good :o) Seems much quicker.
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"