MaximoAccess

Caro Usuário, antes de postar pela primeira vez, leia as regras do fórum.

https://www.maximoaccess.com/t48-regras-do-forum

Obrigado

Administração


Participe do fórum, é rápido e fácil

MaximoAccess

Caro Usuário, antes de postar pela primeira vez, leia as regras do fórum.

https://www.maximoaccess.com/t48-regras-do-forum

Obrigado

Administração

MaximoAccess

Gostaria de reagir a esta mensagem? Crie uma conta em poucos cliques ou inicie sessão para continuar.

Dicas Ms Access, Exemplos Ms Access, Codigos VBA Ms Access, SQL Ms Access


    Perfomance Access

    avatar
    ricardopb
    Novato
    Novato


    Respeito às regras : Respeito às Regras 100%

    Sexo : Masculino
    Localização : Brasil
    Mensagens : 9
    Registrado : 10/09/2013

    Perfomance Access Empty Perfomance Access

    Mensagem  ricardopb 7/4/2016, 22:59

    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.

      Data/hora atual: 28/3/2024, 13:49