django - How many items can be used for list based filtering -

let's doing like

user.objects.filter(username=[user1, user2, user3])

what want understand how large list users can be?

e.g. think it's ok have 1-100 items there. if end adding 10k or more items?

how query work in case?

according this answer, maximum elements of python list on 32 bit system 536,870,912 elements.

how query work depend on amount of memory, cpu, database used, etc. suggest benchmarking on system you're planning use sample objects.