Log file Viewer

[03:46:59] <kkoomen> Hi, should I use the .cursor() nowadays to fetch a lot of data?

[13:12:50] <DrD33M> Hi I am wondering if anybody can help optimize my db. Currently I have a "image" schema {image_id: "xx", user_id: "xx, ts:"xx"}. The queries that will be done often to the DB are checking a image_id exists in the db and getting all image_ids with of a user_id. Currently I have in my test db 2 million entries and the query time is around 1.2 seconds I would like to make it a little faster if

[13:12:50] <DrD33M> possible my my understanding of indexes is limited

[16:07:57] <lacrymology> is it possible to get either the original value or the result from an update? the context is: I've got concurrent processes trying to decrease an inventory value, I need that update never to go <0, I need to decrease as much as possible, and I need to know how many I actually decreased