How to get large items from a table
harryxiyou <[email protected]> Wed, 2 Apr 2014 22:16:36 +0800
| Newsgroups | gmane.comp.db.mysql.devel |
|---|---|
| Message-ID | <CAD+1EGPYfViaJivbkLN7DjH8fy+-YpJXRJG8yLXeTuBWNgyobQ@mail.gmail.com> |
Hi all, I am designing and implementing a database upon a KV storage system. Now, I wonder how to realize "select * from table" with high performance if there are large amount of KV pairs in a table, which RAM cannot load all the KV pairs in the table once. Now, I have a simple solution which would load a default cursor (actually, it should be called "kv pair numbers per time") number of KV pairs one time (So it may load many times and reply to the select all request) in RAM. I am looking forward to receiving some suggestions from you. Thanks, Harry. -- MySQL Internals Mailing List For list archives: http://lists.mysql.com/internals To unsubscribe: http://lists.mysql.com/internals