Changeset 164 for trunk/install

Timestamp:

04/18/2006 06:10:06 AM (6 years ago)

Author:

cirrus

Message:

Optimization: Added 3 key index on the links table.
Optimization: Changed the db_data function in the table class, to avoid a duplicate query.
Thanks to Winner.

File:

• trunk/install/schema.sql (modified) (1 diff)

trunk/install/schema.sql

@@ -107 +107 @@
   `info` text,
   PRIMARY KEY  (`id`),
-  KEY `node_id` (`node_id`),
-  KEY `peer_node_id` (`peer_node_id`),
+  KEY `node_id` (`node_id`,`type`,`status`),
+  KEY `peer_node_id` (`peer_node_id`,`type`,`status`),
   KEY `type` (`type`),
   KEY `status` (`status`),
-  KEY `peer_ap_id` (`peer_ap_id`)
+  KEY `peer_ap_id` (`peer_ap_id`,`type`,`status`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;