MaximoAccess

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

Obrigado

Administração do MaximoAccess

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

    Perfomance Access

    Compartilhe

    ricardopb
    Novato
    Novato

    Respeito às Regras 100%

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

    Perfomance Access

    Mensagem  ricardopb em 7/4/2016, 21: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: 22/10/2017, 16:44