目录1. 优化 SQL 语句避免全表扫描减少子查http://www.devze.com询,改用 JOIN避免SELECT2. 合理使用索引3. 优化存储过程结构减少循环和临时变量避免重复计算4. 使用临时表和缓存5. 优化事务处理6. 分析和监控性能7.
I want to update a file using FLex3/AIR File class. I know how to do this , but before writing(updating) to file i want to check if current file is open in the OS or some 开发者_运维百科other applicat