The table has only two column. One is key, the other is value. The key is like sequencial number from 1,2,3,...N.
I want to search many values at the same time by providing the list of keys for saving time rather than one by one by calling mnesia:read/N. Is it possible? The key lists may be like '1, 21, 55' not have some rule.
mnesia db query, multi key search at the same time
461 Views Asked by Chen Yu At
1
There are 1 best solutions below
Related Questions in ERLANG
- Using gleam, cannot import 'gleam/otp/process'
- Zig Concurrency Vs Erlang Concurrency, is Zig less efficient than Erlang?
- Creaating a new Key Value dict from previous dict
- How to execute an exit function before closing rebar3 shell?
- rebar3 does not compile anything in `src` directory
- Ejabberd Migration from 23 to 24
- How to use compiled erlang modules in an elixir project?
- ejabberd_sql:handle_reconnect/2:491 odbc connection failed ejabberd
- Lisp Flavored Erlang: Can't find include lib include/ltest-macros.lfe
- Signing key for RabbitMQ
- Rabbitmq fails to start and getting Erlang eaacces error
- Erlang: binary_to_term explanation
- How to extend emqx clientInfo to get more fields during HTTP Authorization
- Transforming `erl_parse:abstract_form()` to `erl_syntax:syntaxTree()`
- Who is the sender of Erlang's trace messages and what can I assume based on it?
Related Questions in MNESIA
- How to stop messages from piling up in msg_store_persistent in mnesia folder?
- Erlang, creating mnesia table index
- How does mnesia sync disc_copies with other nodes / PCs?
- ejabberd server overloads at 1080 active users
- init / sync mnesia on distributed rebar3 app
- Erlang: how to spawn a node and link it to a mnesia table
- load an existing mnesia db from files .DCD .DCL
- Erlang rebar3 builds
- Erlang database server nodedown error, can not get mnesia database data through database logic
- Select data rows with condition Erlang
- Reading history on the server ejabberd (mnesia)
- Mneisa table memory does not match size in DCD file
- How to test mnesia system events
- High erlang process memory executing mnesia:dirty_select/2
- Erlang Database Join Association
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
The table is really small, so non of ets:match nor select will make a difference. The only optimization I see is to use dirty_read and do not wrap in transaction each read.
I am not sure here, but due to the nature of mnesia linear hashing, there is no bulk read hidden API. If your keys can be totally random, it would not help anyway.