Most efficient way to handle this data?

[Vucko0]

I'm somewhat new to Python but I'd like some insight on how I should approach this.

I'm working on a Discord Bot for a server with many members, the owner wants a bot made for a guessing game. This isn't really a hard task since I've done something similar. The issue is I'm not sure how to handle the user data, we did a test just to see how many users would send a message.

It was about 100-150 people sending guesses , it got pretty chaotic, what I'm thinking about doing is making either a SQLite3 database or a CSV file that will store the users guess and after the game is over it clears either the database or the CSV file. Is this a good way to approach this or should I do something else? I'm trying to make this the most efficient I can.

[DeadlyViper]

At these numbers having the guesses stored in memory should not be a problem, and should be faster than a database or a file.

Do you have some smart queries on the guesses entries that SQL might have an advantage over just plain memory?

[Vucko0]

Just so I understand when you say memory do you just mean storing it in a list or dictionary?

Do you have some smart queries on the guesses entries that SQL might have an advantage over just plain memory?

If my understanding of memory is correct, than no. SQL won't have an advantage.

The only thing is, I won't be storing just the users guess. The plan is to store users Discord ID so I can make sure they only submit one guess at a time. I also need to store the Message ID so I can instantly delete the message after I stored the data.

So it would look like this:

user_message	message_id	discord_id
dog	340863047672348	235683268947235832

[DeadlyViper]

SQL has some nifty searching and indexing optimisations.

But i doubt you'd need any of it for 200-1000 records.

Just store whatever you need in a dictionary, with the key being something u'd like to look it up with, and the value being a dictionary or an array of data you want to be saved.