PHP和SQLite：如何处理大数据和高并发

<?php
// 创建SQLite数据库连接
$pdo = new PDO('sqlite:mydatabase.sqlite');

// 执行插入操作
$pdo->beginTransaction();
for ($i = 1; $i <= 10000; $i++) {
    $pdo->exec("INSERT INTO mytable (id, name) VALUES ($i, 'Name $i')");
}
$pdo->commit();

// 执行查询操作
$stmt = $pdo->query("SELECT * FROM mytable");
while ($row = $stmt->fetch()) {
    echo $row['id'] . ' - ' . $row['name'] . '<br>';
}

// 关闭连接
$pdo = null;
?>

<?php
class SQLiteConnection {
    private static $db = null;

    public static function getConnection() {
        if (self::$db == null) {
            self::$db = new PDO('sqlite:mydatabase.sqlite');
            self::$db->exec('PRAGMA journal_mode = WAL;');
        }
        return self::$db;
    }
}

class Task {
    private $db;

    public function __construct() {
        $this->db = SQLiteConnection::getConnection();
    }

    public function process() {
        $this->db->beginTransaction();
        // 具体的业务逻辑处理
        $this->db->commit();
    }
}

$task1 = new Task();
$task2 = new Task();

// 在多个线程或进程中同时执行Task的process方法
$task1->process();
$task2->process();
?>