12章 Index Shotgun(闇雲インデックス) - Qiita
CREATE TABLE Mikosan ( miko_id SERIAL PRIMARY KEY, date_joined DATE NOT NULL, description VARCHAR(128) NOT NULL, status VARCHAR(10) NOT NULL, hours NUMERIC(9.2), INDEX(miko_id), INDEX(description), INDEX(hours), INDEX(miko_id, date_joined, status) ); mysql> show index from Mikosan; +---------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+----
PHP singleton database connection pattern
I've been working on a small project using PHP and MySQL. I've read a lot around about best practices on managing a connection and so on. I've also implemented (following some posts found around) a singleton class to manage MySQL connections. require_once 'config.inc.php'; class DbConn { private static $instance; private $dbConn; private function __construct() {} /** * * @return DbConn */ private
1
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
処理を実行中です
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
