|
|
|
|
|
|
by pjungwir
3997 days ago
|
|
|
Definitely agree re bulk inserting, say every 1 minute or 1 hour or whatever. I was paying around recently with Amazon's Kinesis for this, but if you don't want the vendor lock-in you could easily roll your own system that bundles up events and stores a bunch at once. |
|
|
open database connection
do one insert
close database connection
That adds up fast.
At work, I've been very disappointed in the performance of their Amazon RDS. They had unexplained master/slave replication issues.
You also can put a memcached in front of the database.