On 3/5/2023 9:05 PM, Thomas Passin wrote:

I would probably ingest the data at startup into a dictionary - or perhaps several depending on your access patterns - and then you will only need to to a fast lookup in one or more dictionaries.

If your access pattern would be easier with SQL queries, load the data into an SQLite database on startup.

Thank you. SQLite would be overkill here, plus all the machinery that I would need to set up to make sure that the DB is rebuilt/updated regularly.
Do you happen to know something about Whoosh? have you ever used it?

IOW, do the bulk of the work once at startup.

Sound advice

Thank you
--
https://mail.python.org/mailman/listinfo/python-list

Reply via email to