Question about concurrent connections limitation

Discussion in 'Databases' started by jetbrains, Mar 4, 2007.

0
  1. #1
    I found my host doesn't allow me to have more than 20 concurrent connections at any given time. Would you like to tell me what it means? Does it mean that I can't have 20 visitors online?

    Thanks in adcance
     
    jetbrains, Mar 4, 2007 IP
    abixalmon likes this.
  2. abixalmon

    abixalmon Well-Known Member

    Messages:
    378
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    120
    #2
    i think it doesn't mean that!

    Request more than 20 will processed in queue! (Queue of 20 request at once)
     
    abixalmon, Mar 4, 2007 IP
    jetbrains likes this.
  3. ccoonen

    ccoonen Well-Known Member

    Messages:
    1,606
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    160
    #3
    20 people at a time connecting to your database, Their are ways to better this - for instance in ASP - always do this:
    Connect to DB,
    GetRows() your data - creates 2 dim array of data
    Close connection to DB
    Display data

    Same with PHP - run your queries first, then close ur db connection and display the page. Always try to get in and out of the db as FAST as possible and you shouldn't run into issues.
     
    ccoonen, Mar 5, 2007 IP
  4. Your Content

    Your Content Banned

    Messages:
    1,096
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Very true, as in example my core script has this statement:

    
@mysql_close($dbc);
@mysql_close();
    Code (markup):
     
    Your Content, Mar 6, 2007 IP