[04:18:18] <dman777> if I have a field pets: [ { "fido": 1231232 }, { "felix": 33423233 } ], could I index pets array? I read about multi-key and compound indexes but didn't see this type of use case in the examples.... and compound index doesn't really even apply to this one
[04:20:57] <dman777> oh wait...just ran across https://docs.mongodb.org/manual/core/index-multikey/#index-arrays-with-embedded-documents
[04:52:45] <dman777> I assume a index on a field with a object id is faster than a indexed string field, correct? If I had a field on user called pets.... pets: [ { name: "fido", ref_objectId: 456564 } ]... would I just createIndex({"pets.name")) to get the object id and look up the pets record by object id?
[05:10:43] <Freman> is it possible to make mongo insert into 2 collections the same data at the same time? ie. one capped/live collection and one that is unique to the month (with the intention of keeping the month around for a couple of months then archiving to disk?) - bearing in mind... I'd rather just write the lot to disk and never use the mongo :D
[05:11:27] <Freman> not that there's anything wrong with mongo just our abuse of it
[05:12:12] <dman777> Freman: you can insert multiple documents at the same time.... one second
[05:14:08] <dman777> there's no write lock since they are on seperate collections
[05:17:02] <dman777> you could also do setimmediate(doThis); setimmediate(doThat) but the former has better perfomance in my experience. Really, though... it these are purely just I/O you can just doThis(); doThat() and they would be non blocking
[05:17:47] <dman777> meaning doThis() is db.collection.insert().... not sure, though, if it's purley I/O...for instance, I use node mongodb driver
[05:34:22] <reduxredux> Hi all, are there any other characters in a fully qualified index name other than database.collection.$indexname ? My mongoimport fails claiming it's greater than 128 chars.. I think it is *exactly* 128 (trivial I know :-/ )
[05:40:24] <reduxredux> Ah, it looks like I'm on the version where the limit was actually 125 :(
[10:54:29] <synthmeat> mongoose stopped making pool of connections for me :/