#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    1
    Rep Power
    0

    Optimize my database


    hi,
    I have thousands of users connected to the database from my website. sometimes this database spits and people can no longer access to the DB.SoI have a question : howcan i optimise up my database (maximum number of requests / s maximum user is /s...)? and if I have alot of query how to made a FIFO queue for untreated request ?

    thanks,
    ps:excuse my poor english
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,781
    Rep Power
    348
    This question is far too unspecific and broad for anyone to be able to answer it.

    You might want to read this:
    https://wiki.postgresql.org/wiki/Slow_Query_Questions

    To understand how to post questions about performance.

    Before that you might want to go through:
    https://wiki.postgresql.org/wiki/Performance_Optimization

    to get some ideas on where to start your investigation.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
    http://forums.devshed.com/misc.php?do=bbcode#code

    Tips on how to ask better questions:
    http://tkyte.blogspot.de/2005/06/how-to-ask-questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Location
    Usually Japan when not on contract
    Posts
    240
    Rep Power
    12
    This question is so broad that we don't even know if its a database issue. You need to explain in at least some detail how your server is setup (webserver software, webframework, etc.), and if the webserver and the database server are the same machine/instance.

IMN logo majestic logo threadwatch logo seochat tools logo