Tip - IIS 7 + Vista + ASP

本文档提供了在IIS7环境下调试ASP的具体步骤:包括启用ASP、配置IIS中的ASP设置以及设置IE以显示ASP页面错误信息的方法。通过这些步骤可以有效地定位并解决ASP页面在IIS7上出现的问题。
无法一下子想不起来的事情,最好写下来备查。如何在IIS7 (Vista)下调试ASP:

1. 启用ASP



2. 配置IIS中的ASP设置



3. ASP页面报错时,让IE显示错误信息
3.1设置IE


3.2 执行命令:%windir%/system32/inetsrv/appcmd set config -section:asp -scriptErrorSentToBrowser:true
http://blogs.iis.net/thomad/archive/2007/02/06/security-is-painful.aspx

update: found this blog - http://blogs.iis.net/bills/archive/2007/05/21/tips-for-classic-asp-developers-on-iis7.aspx
按照你的方案 我加了索引 索引信息如下 mysql> SHOW INDEX FROM md_elevator_mode_switch_record_transfer; +-----------------------------------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-----------------------------------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | md_elevator_mode_switch_record_transfer | 0 | PRIMARY | 1 | id | A | 2200838 | NULL | NULL | | BTREE | | | | md_elevator_mode_switch_record_transfer | 1 | elevator_id | 1 | elevator_id | A | 23664 | NULL | NULL | YES | BTREE | | | | md_elevator_mode_switch_record_transfer | 1 | event_config_id | 1 | event_config_id | A | 2674 | NULL | NULL | YES | BTREE | | | | md_elevator_mode_switch_record_transfer | 1 | happened_time | 1 | happened_time | A | 2200838 | NULL | NULL | YES | BTREE | | | | md_elevator_mode_switch_record_transfer | 1 | serial_number | 1 | serial_number | A | 2200838 | NULL | NULL | YES | BTREE | | | | md_elevator_mode_switch_record_transfer | 1 | idx_event_time | 1 | event_config_id | A | 993 | 20 | NULL | YES | BTREE | | | | md_elevator_mode_switch_record_transfer | 1 | idx_event_time | 2 | happened_time | A | 2200838 | NULL | NULL | YES | BTREE | | | | md_elevator_mode_switch_record_transfer | 1 | idx_event_time | 3 | elevator_id | A | 2200838 | 64 | NULL | YES | BTREE | | | | md_elevator_mode_switch_record_transfer | 1 | idx_event_time | 4 | serial_number | A | 2200838 | 64 | NULL | YES | BTREE | | | +-----------------------------------------+------------+-----------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 9 rows in set (0.06 sec) mysql> SHOW INDEX FROM view_terminal_jinshan_sh_table; +--------------------------------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +--------------------------------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | view_terminal_jinshan_sh_table | 0 | PRIMARY | 1 | elevator_id | A | 3491 | NULL | NULL | | BTREE | | | | view_terminal_jinshan_sh_table | 1 | terminal_id | 1 | terminal_id | A | 3491 | NULL | NULL | | BTREE | | | +--------------------------------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 2 rows in set (0.00 sec) EXPLAIN SELECT memsc.happened_time AS "happenedTime", memsc.serial_number AS "serialNumber", memsc.elevator_id AS "elevatorId", memsc.event_config_id AS "eventConfigId", view1.terminal_id AS "terminalId" FROM md_elevator_mode_switch_record_transfer memsc INNER JOIN view_terminal_jinshan_sh_table view1 ON memsc.elevator_id = view1.elevator_id -- 使用电梯ID连接 LEFT JOIN om_record_ysy ory ON ory.event_id = memsc.serial_number WHERE memsc.event_config_id IN ('491','492','493') AND memsc.happened_time BETWEEN DATE_SUB(NOW(), INTERVAL 30 MINUTE) AND DATE_SUB(NOW(), INTERVAL 10 MINUTE) AND ory.event_id IS NULL -- 替换NOT EXISTS ORDER BY memsc.happened_time DESC;使用这个sql语句还是很慢 需要20秒以上 下面是explain结果 1 SIMPLE view1 index PRIMARY terminal_id 77 3491 Using index; Using temporary; Using filesort 1 SIMPLE memsc ref elevator_id,event_config_id,happened_time,idx_event_time elevator_id 387 smartelevatorguard.view1.elevator_id 93 Using index condition; Using where 1 SIMPLE ory ref event_id event_id 194 smartelevatorguard.memsc.serial_number 1 Using where; Not exists; Using index
06-11
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值