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:
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
|
|