dtz46697 2016-05-25 07:31
浏览 31
已采纳

使用Redis DB的Php分页

I want to display list of customers with pagination.Structure of DB is as follow:

redis:> hset customerlist username userid (where username:almas userid:1)
redis:> hmset customerlog:1 userid value1 name value2 contactno value3
(where value1:1 , value2: almas sayyad, value3: 8676756556)

I have used hash set and want to continue with same datatype. I will be greatfull if any one can give me the solution for this.

  • 写回答

1条回答 默认 最新

  • douliao8402 2016-05-25 13:52
    关注

    TL;DR Paginating a Hash isn't trivial - you should consider using a different data structure that is more suitable for that task, namely the Sorted Set.

    Hashes have no order and the only way to sanely iterate their fields is with HSCAN. However, scanning is unordered, can return duplicates and the number of results from each call varies - building a pagination mechanism on top of that is challenging and inefficient.

    You can keep the data, i.e. users, in a Hash, but store the field names in a Sorted Set as well. You can give each user a score to order them or just use lexicographical ordering - either way, you'll be able to paginate with the Sorted Set.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 执行 virtuoso 命令后,界面没有,cadence 启动不起来
  • ¥50 comfyui下连接animatediff节点生成视频质量非常差的原因
  • ¥20 有关区间dp的问题求解
  • ¥15 多电路系统共用电源的串扰问题
  • ¥15 slam rangenet++配置
  • ¥15 有没有研究水声通信方面的帮我改俩matlab代码
  • ¥15 ubuntu子系统密码忘记
  • ¥15 保护模式-系统加载-段寄存器
  • ¥15 电脑桌面设定一个区域禁止鼠标操作
  • ¥15 求NPF226060磁芯的详细资料