PHP开发中如何处理大量数据存储和查询

CREATE TABLE users (
    id INT(11) NOT NULL AUTO_INCREMENT,
    name VARCHAR(50) NOT NULL,
    email VARCHAR(50) NOT NULL,
    PRIMARY KEY (id),
    INDEX idx_email (email)
);

$pageSize = 10;  // 每页显示的记录数
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;  // 当前页码

$start = ($page - 1) * $pageSize;

$sql = "SELECT * FROM users LIMIT {$start}, {$pageSize}";
$result = $conn->query($sql);

while ($row = $result->fetch_assoc()) {
    // 处理每一行数据
}

$redis = new Redis();
$redis->connect('127.0.0.1', 6379);

$key = 'users_data';

// 先查看缓存中是否有数据
$data = $redis->get($key);

if (!$data) {
    $sql = "SELECT * FROM users";
    $result = $conn->query($sql);

    $data = serialize($result->fetch_all());

    // 将数据存入缓存，并设置过期时间
    $redis->set($key, $data);
    $redis->expire($key, 3600);  // 缓存1小时
}

$users = unserialize($data);
foreach ($users as $user) {
    // 处理每一行数据
}