| Posted by Bernd Kohler on 05/27/05 11:39 
Hello,
 some little questions relating LAMP (PHP 4.3.4, MySQL 3.x, Apache):
 I'm trying to build a community website which needs many db-querys for lots
 of concurrent users.
 Therefore I'm always using:
 $ergebnis = mysql_query ($sql) or die (mysql_error());
 while ($row = mysql_fetch_array($ergebnis))
 {
 $myvar = $row['column_xy'];
 }
 
 Is there a limit for db-connections under MySQL3.x?
 What happens if hundreds of users are accessing these pages simultaneously?
 I heard MySQL breaks down if there are more than 200 users!?
 
 Is there a better/more efficient way for the db-queries under PHP4?
 How efficient would it be to write all possible db-results into
 session-variables in order to keep the number of queries low?
 What about performance using many session-variables?
 
 Thank you very much in anticipation!
 Bernd
  Navigation: [Reply to this message] |