Load bank table per session system

1

I am developing an application, where one of the modules is the product register, and within that register, I have the fiscal part.

In this fiscal part, I have to define an NCM, and consequently the IPI rate, so I created a table with NCM code, description and aliquot, but my table got 10029 records.

My question is, or better, what would be your suggestions, about loading this table once per system section? It would have a classe static , similar to this:

public static class Cidades
{
    private static DataTable _tableCidade;

    public static DataTable Tablecidade
    {
        get { return Cidades._tableCidade; }
        set { Cidades._tableCidade = value; }
    }
}

When logging in to the system, the datatable will be populated with this table of ncm and ipi aliquots.

What do you think?

In analysis, memory consumption, I had a 5 mb increase in consumption, in speed issue, I did not feel the difference between loading it at boot or not loading.

Note: Anyone interested, I can make available, is in SQL language with the latest version removed from the official website.

    
asked by anonymous 11.08.2016 / 04:30

0 answers