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.

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

报告相同问题?

悬赏问题

  • ¥30 求给定范围的全体素数p的(p-2)的连乘积
  • ¥15 VFP如何使用阿里TTS实现文字转语音?
  • ¥100 需要跳转番茄畅听app的adb命令
  • ¥50 寻找一位有逆向游戏盾sdk 应用程序经验的技术
  • ¥15 请问有用MZmine处理 “Waters SYNAPT G2-Si QTOF质谱仪在MSE模式下采集的非靶向数据” 的分析教程吗
  • ¥50 opencv4nodejs 如何安装
  • ¥15 adb push异常 adb: error: 1409-byte write failed: Invalid argument
  • ¥15 nginx反向代理获取ip,java获取真实ip
  • ¥15 eda:门禁系统设计
  • ¥50 如何使用js去调用vscode-js-debugger的方法去调试网页