Tenho um BD de contabilidade. Como são 20 milhões de registros não coube tudo num unico arquivo e tive que dividir em 3 arquivos de 2gb. Para fazer consultas, com LIKE, estou usando uma consulta Union nas tabelas dos 3 BDs. Nem preciso dizer que é muito lento e frequentemente trava o Access.
Pesquisando na Internet vi que existem algumas chaves do JET que podem ser modificados no Registro do Windows. Alguem já fez isso e sabe quais chaves e valores eu deveria modificar no meu caso?
As que encontrei são as seguintes:
Threads
Experiment with the Threads setting in the registry. With this setting you can increase or decrease the number of operating system threads available to the Jet database engine.
MaxBufferSize
Use the MaxBufferSize registry setting to tune the data buffer used by the Jet database engine.
UserCommitSync
Use the UserCommitSync registry setting to tune performance of explicit transactions.
ImplicitCommitSync
Use the ImplicitCommitSync registry setting to tune the performance of implicit transactions.
FlushTransactionTimeout
Use the FlushTransactionTimeout registry setting to tune the performance of asynchronous write operations.
ExclusiveAsyncDelay
Use the ExclusiveAsyncDelay registry setting to tune the performance of asynchronous mode writes to exclusively opened databases.
SharedAsyncDelay
Use the SharedAsyncDelay registry setting to tune the performance of asynchronous mode writes to databases opened for shared access.
PageTimeout
Use the PageTimeout registry setting to change the delay for checking other user's changes to the database.
LockDelay
Use the LockDelay registry setting to change how long Microsoft Jet waits between retries on locked pages in a shared database.
MaxLocksPerFile
Use the MaxLocksPerFile registry setting to tune performance by setting the maximum number of locks can be placed on a database (MDB) file. For more information, search Access online help for "Customizing Windows Registry Settings for Data Access Objects", or read this Microsoft Knowledgebase article "File sharing lock count exceeded…" error message during large transaction processing.
RecycleLVs
Use the RecycleLVs registry setting to determine how to memo, OLE and hyperlink data pages are recycled.
Use ISAMStats to See Engine Detail
Microsoft Jet contains an undocumented function called ISAMStats that shows various internal values. The syntax of the function is as follows.
Pesquisando na Internet vi que existem algumas chaves do JET que podem ser modificados no Registro do Windows. Alguem já fez isso e sabe quais chaves e valores eu deveria modificar no meu caso?
As que encontrei são as seguintes:
Threads
Experiment with the Threads setting in the registry. With this setting you can increase or decrease the number of operating system threads available to the Jet database engine.
MaxBufferSize
Use the MaxBufferSize registry setting to tune the data buffer used by the Jet database engine.
UserCommitSync
Use the UserCommitSync registry setting to tune performance of explicit transactions.
ImplicitCommitSync
Use the ImplicitCommitSync registry setting to tune the performance of implicit transactions.
FlushTransactionTimeout
Use the FlushTransactionTimeout registry setting to tune the performance of asynchronous write operations.
ExclusiveAsyncDelay
Use the ExclusiveAsyncDelay registry setting to tune the performance of asynchronous mode writes to exclusively opened databases.
SharedAsyncDelay
Use the SharedAsyncDelay registry setting to tune the performance of asynchronous mode writes to databases opened for shared access.
PageTimeout
Use the PageTimeout registry setting to change the delay for checking other user's changes to the database.
LockDelay
Use the LockDelay registry setting to change how long Microsoft Jet waits between retries on locked pages in a shared database.
MaxLocksPerFile
Use the MaxLocksPerFile registry setting to tune performance by setting the maximum number of locks can be placed on a database (MDB) file. For more information, search Access online help for "Customizing Windows Registry Settings for Data Access Objects", or read this Microsoft Knowledgebase article "File sharing lock count exceeded…" error message during large transaction processing.
RecycleLVs
Use the RecycleLVs registry setting to determine how to memo, OLE and hyperlink data pages are recycled.
Use ISAMStats to See Engine Detail
Microsoft Jet contains an undocumented function called ISAMStats that shows various internal values. The syntax of the function is as follows.