[mihai11]

Originally Posted by Marco van Herwaarden

An in MEMORY (HEAP) table is cleared on each restart of the MySQL server and not suitable for permanent storage (hence why vB only uses HEAP for session tables).

You can find various articles that include information on how to use the datastore, one of them: Cache System Explanation (datastore)

PS Using the datastore can reduce the number of queries as vBulletin already read all needed rows from the table.

What you suggested is the BEST solution. The relevant part is this:

So instead of running a query everytime you want to get the drop down information, you just get it from the datastore and save that query.

Exactly what I was looking for. Thank you.