Beefy Boxes and Bandwidth Generously Provided by pair Networks
Come for the quick hacks, stay for the epiphanies.
 
PerlMonks  

comment on

( [id://3333]=superdoc: print w/replies, xml ) Need Help??

You imply that the process forks for each request received, and that the forked copy attempts to do an insert.

This is a strategy that is, IMHO, inherently unstable (and easily “flooded”).

A much better strategy would be to have an app that simply consists of two threads or processes:

  • The main, or “listener,” thread waits for requests to arrive.   When they do, it writes a record to a queue.
  • The child, or “writer” thread waits for a message to arrive in the queue, then posts it to the database.

So, if a flood of inputs comes in, they simply pile-up (briefly...) in the queue.   The writer-process disposes of them as quickly as it can ... while never overwhelming the underlying database server.   The listener-process can reply immediately, saying in effect that “your request has been accepted,” knowing that the writer will “lazily” post it to the database.   From the database server’s point of view, this app might be a “busy” client, but it is also an “uncomplicated” one.


In reply to Re: to "use vars" or not to by sundialsvc4
in thread to "use vars" or not to by westy032001

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":



  • Are you posting in the right place? Check out Where do I post X? to know for sure.
  • Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
    <code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
  • Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
  • Want more info? How to link or How to display code and escape characters are good places to start.
Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others rifling through the Monastery: (3)
As of 2024-03-28 18:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found