RE: [PHP] DB-License usage

No hard-and-fast formula, but you could rough something out: u = number concurrent users accessing a page. l = time in seconds needed to populate the page dynamically with database info for a user. s = time in seconds a user will spend the page d = concurrent database sessions (licenses) so d = u(l/s) e.g. 1 second needed to load the data for a page that an average of 100 users will stay on for 20 seconds means 5 database connections needed. You can further eliminate database calls by passing info from page to page in variables where the data is the same. This becomes especially important where the bulk of each page is database-driven, or even all of them. You would then pass session variables, etc from page to page instead of forcing a db call. e.g.,create an array for the navigation structures and other infrequently changing page objects, and read all those variables in only once for each session. Best regards, Andrew ---------------------------------------------------- Andrew Hill Director Technology Evangelism OpenLink Software http://www.openlinksw.com XML & E-Business Infrastructure Technology Provider > -----Original Message----- > From: Herman Tolentino MD [mailto:hermant@i-manila.com.ph] > Sent: Monday, October 02, 2000 2:26 PM > To: ahill@openlinksw.com > Subject: RE: [PHP] DB-License usage > > > Is there a formula that one can apply in this situation? > > Herman D. Tolentino, MD > Associate Professor I > University of the Philippines College of Medicine > Medical Informatics Unit [ http://cm1.upm.edu.ph/miu/ ] > Email: hermant@i-manila.com.ph ICQ No.: 52662721 > Web Site: http://www.veranda.com.ph/hermant > > > -----Original Message----- > > From: Andrew Hill [mailto:ahill@openlinksw.com] > > Sent: Monday, October 02, 2000 10:18 PM > > To: Bjorn Andre Lie; php-general@lists.php.net > > Subject: RE: [PHP] DB-License usage > > > > > > This depends entirely on the architecture of your php and the type of > > connections that your db supports. > > > > E.g. intelligent use of cursors and persistent connections will > > allow you to > > pull chunks of data in for each user. At that point you only > > have to allow > > for x number of concurrent users as they hit the page. So if > > your site runs > > 1000 concurrent users, you prob. will have only 10-25 > concurrent database > > connections. > > > > You can also look at faster / cheaper databases than Sybase and Oracle: > > www.openlinksw.com/virtuoso > > > > Best regards, > > Andrew > > ---------------------------------------------------- > > Andrew Hill > > Director Technology Evangelism > > OpenLink Software > > http://www.openlinksw.com > > XML & E-Business Infrastructure Technology Provider > > > > > > > -----Original Message----- > > > From: Bjorn Andre Lie [mailto:Bjorn.Andre.Lie@LightWare.no] > > > Sent: Saturday, September 30, 2000 5:04 AM > > > To: php-general@lists.php.net > > > Subject: [PHP] DB-License usage > > > > > > > > > > > > Hi ! > > > > > > Is the PHP engine using one connecion to the database for each user > > > accessing a page using a DB-engine of some kind (eg Sybase > > SQL-AnyWhere). > > > > > > If this is the case - a site with many visitors will need a big > > > DB-license > > > (expensive !!!!). > > > > > > > > > Any thoughts ? > > > > > > Regards, > > > Bjørn André Lie > > > > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > > For additional commands, e-mail: php-general-help@lists.php.net > > > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > > > > > > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > >