This is the ‘sequel’ to this:
By ‘sequel’, I mean that this is actually the problem I am having.
Aldric G. wrote:
Okay, I finally got a clear look at the log, and it is indeed how it
seems - all the transactions to the database are queued until I actually
look at the database.
The DB I am using is SQLite3. How do I force ActiveRecord / SQLite /
Rails to commit / process the transaction so it happens in a better type
of real-time than that?
I’m looking for something like an update/commit/force/process/execute
statement to tell the DB to do its update now, and not next time someone
goes “What if I looked at that list of reports ?”
When I came in this morning, it was processing the background job which
runs every five minutes - I saw the DB (at 8am) go through the updates
from midnight to then. I don’t know if someone had clicked to view the
report or if the buffer was full or what… But this is just
unacceptable behavior, you know?
And sadly, mysql or oracle or postgresql aren’t choices for me at the