How to build a high-performance inserted index for unordered fields

Question

I now have a table that needs to insert about 2,000 pieces of data per second. There is an unordered Bigint field that needs to be built into an index. However, I found that the performance cannot meet the demand. Is there any good way?

Answer 1

the correct views/template.xml is

<odoo>
    <data>
        <template id="assets_frontend" name="library_website_assets" inherit_id="website.assets_frontend">
            <xpath expr="." position="inside">
                <script type="text/javascript" src="/upobeer/static/src/js/functions.js"></script>
            </xpath>
        </template>
    </data>
</odoo>