Community mailing list archives
Re: Slowness, customersby
Den 2015-05-12 10:35, Torvald Baade Bringsvor skrev:<blockquote cite="mid:CAGWx-g_nO6DJeHs_0vBE2OZtAhG=0XdsuCtoTnaY20Mff5d-tQ@mail.gmail.com" type="cite">
We have in our database now 8500 invoices. The problem we are seeing is slowness in the usage of the system. For example when you open some of the larger customers (our largest one has 659 invoices) it takes several minutes to open. Also opening the customer invoices list (for all invoices) is getting rather slow. We only have two users so it should not be related to concurrency issues.
Are there any known issues here that we should be aware of? Any general tricks to analyze performance of Odoo? Cool database queries I don't know about?
Sometimes you have to add new indexes to optimize the performance. In earlier versions we have had some not well formed postgres-views that could get you in trouble when data increases. (We have one installation that creates 500 000 invoices per year).
<blockquote cite="mid:CAGWx-g_nO6DJeHs_0vBE2OZtAhG=0XdsuCtoTnaY20Mff5d-tQ@mail.gmail.com" type="cite">
Torvald Baade Bringsvor
Bringsvor Consulting AS - Odoo (formerly OpenERP) implementation partner