Log file Viewer

[07:17:26] <wfq> morning guys

[07:18:39] <wfq> Is there any Mongo client similar to Mysql-client that I can use to interact with my remote mongo server? I have installed robomongo but apparently I am unable to use mongorestore

[07:19:12] <wfq> given that mongorestore ain't a command you can use while in the mongo shell

[07:20:05] <wfq> sorry, just found: https://dba.stackexchange.com/questions/196330/is-it-possible-to-install-just-the-mongo-shell

[08:31:10] <Derick> there is also Compass: https://docs.mongodb.com/compass/current/connect/

[10:00:15] <ajph> hi. i have a small document that doesn't change much in size. i very frequently do an inc upsert to one of the number fields (think - a credit/balance subtraction) in this document. is there any benefit to an index on this field in this scenario?

[10:13:30] <Derick> what's the criterium you do that update on?

[10:42:57] <ajph> it's an analytics type scenario so it's very frequent and done in a Bulk() operation every 10 seconds

[10:43:15] <ajph> so it's a Find on an ID and Update with upsert + inc

[10:43:45] <Derick> do your only index should be on the ID

[10:44:05] <Derick> indexes are used for *finding* things (for either a read, or an update)