tuning-increase-db-performance.rst
23 lines
| 911 B
| text/x-rst
|
RstLexer
| r1 | .. _db-session-ref: | |||
| Increase Database Performance | ||||
| ----------------------------- | ||||
| To increase database performance switch to database-based user sessions. | ||||
| File-based sessions are only suitable for smaller setups. The most common | ||||
| issue being file limit errors which occur if there are lots of session files. | ||||
| Therefore, in a large scale deployment, to give better performance, | ||||
| scalability, and maintainability we recommend switching from file-based | ||||
| sessions to database-based user sessions. | ||||
| To switch to database-based user sessions uncomment the following section in | ||||
| your :file:`/home/{user}/.rccontrol/{instance-id}/rhodecode.ini` file. | ||||
| .. code-block:: ini | ||||
| # db session | ||||
| beaker.session.type = ext:database | ||||
| # adjust this property to include your database credentials | ||||
| beaker.session.sa.url = postgresql://postgres:<pass>@localhost/rhodecode | ||||
| beaker.session.table_name = db_session | ||||
