Quote:
Originally Posted by k0nr4d
With that reasoning, it would be better to use a mysql memory table as a buffer and insert into that, as if you are inserting into a log file you will have several issues.
- Constant IO Writes
- Write-locks on the log, since only 1 process can write to it at once.
|
Yep, i used similar approach with other type of script, till i switched to memcache which is far smoother method to deal with it.