Version 1 (modified by 16 years ago) ( diff ) | ,
---|
Installation on PostgreSQL
Replacing the simple SQLite database with PostgreSQL allows greater scalability
Suggest to use connection pools to reuse connections:
db=SQLDB('postgres://user:password@hostname/db',pools=20)
How many pools?
whatever you choose it always starts with one and grows with the number of concurrent requests up to the value of pools (the max number of concurrent pools). So pools should be the max number of concurrent requests you expect. That is the max value of: <number of requests/second> / <average time per request in seconcds>
Note:
See TracWiki
for help on using the wiki.