Hi Oxid list, if your site is under heavy load because of many concurrent users, you might want to use persistent connections to your database. A persistent connection keeps a database ressource handle open between requests. Normally it is closed after each page request and a new handle is created. If there are many page requests per second, many ressource handles are opened, used for just this page request and destroyed afterwards. Because oxid uses the same database user on each request, it is waste of time to destroy the db-ressource handle and recreate it. Using a persistent connection bypasses the process of creating the ressource handle because it is not closed. So it can be reused, which should boost up your performance a little bit and reduces load on the database server.
I didn't find this documented for Oxid so I wanted to give you an example. Adodblite supports using persistent connections. All you have to do is to define the variable dbType in your config.inc.php like this: $this->dbType = "mysql://localhost?persistent=1"; The configuration params of your environment must allow persistent connections, too. In php.ini: [MySQL] ; Allow or prevent persistent links. mysql.allow_persistent = On ; Maximum number of persistent links. -1 means no limit. mysql.max_persistent = -1 ; Maximum number of links (persistent + non-persistent). -1 means no limit. mysql.max_links = -1 Best regards, -- Daniel Schlichtholz Mayflower GmbH Pleichertorstraße 2 Tel.: +49 931 359 65 1125 D-97070 Würzburg Fax : +49 931 359 65 28 [email protected] http://www.mayflower.de Mayflower GmbH, Standort Würzburg Firmensitz: Mannhardtstraße 6, 80538 München Registergericht: Amtsgericht München, HRB 142039 Geschäftsführer: Gregor Streng, Björn Schotte, Albrecht Günther, Johann-Peter Hartmann _______________________________________________ dev-general mailing list [email protected] http://dir.gmane.org/gmane.comp.php.oxid.general
