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