2Mike_LV
А вот параметр MaxBufferSize= 0 я выставляю как правило равным 4096, что хорошо для клиентов. Проблем никогда не возникало.
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
MaxBufferSize setting when Access is installed is 0 , which indicates that Microsoft
Jet calculates the setting based on the following formula:
((Total RAM in K - 12 , 288 )/ 4 + 512K)
For computers with 32 MB of RAM, you may see some performance improvement
when specifying a larger MaxBufferSize if no other applications are running at the
same time as Access. For example, tests have shown performance improvements in
applications that perform large transactions when a MaxBufferSize as large as 8 MB
is specified.
Specifying a MaxBufferSize larger than 8 MB hasn’t been found to increase
performance. Setting a value too high can degrade performance due to the added
CPU overhead needed to manage the cache, and due to the fact that the
operating system may start swapping Microsoft Jet’s cache to disk as virtual
memory.
Таким образом ты сообщаешь Jet, что у тебя только 26 624Кб оперативной памяти, которую она и использует. Наплевав на
Microsoft Jet can temporarily exceed the MaxBufferSize
А вообще - нифиг по реестрам лазить, делая "тюнинг" JET'у - лучше с оптимизуруйте программу, расшив узкие места.
