actually it is not the database i think, 
all thumbnails take between .5 and 1 second to show
... they should be cached on the server ? so just serving up a static image 
file should be much faster...


On Thursday, September 7, 2017 at 7:03:49 PM UTC+2, Tony Nys wrote:
>
> Mayan is extremely slow when targeting an external postgres.
> When I run the docker image locally and a local postgres , it is fast;
>
> but when I run towards an external Postgres (in Azure) it is extremely slow
> (5 seconds to show the recent document list page with only 2 docs)
>
> I try to debug the performance, so I'v put this logging inside
>
> /usr/share/mayan-edms/lib/python2.7/site-packages/mayan/settings/local.py
>
>
> However, it only logs the initial DDL of the "initialsetup" phase in mayan 
> db creation
>
> but not the queries and response times executing the SQL
>
>
> this is the log config:
>
>
> LOGGING = {
>
>     'version': 1,
>
>     'disable_existing_loggers': False,
>
>     'handlers': {
>
>         'file': {
>
>             'level': 'DEBUG',
>
>             'class': 'logging.FileHandler',
>
>             'filename': '/var/log/django.debug.log',
>
>         },
>
>     },
>
>     'loggers': {
>
>         'django.db.backends': {
>
>             'handlers': ['file'],
>
>             'level': 'DEBUG',
>
>             'propagate': True,
>
>         },
>
>     },
>
>
> }
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"Mayan EDMS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to