def init(self,cr): tools.sql.drop_view_if_exists(cr, 'custrom_product_infomation_report') cr.execute(""" create or replace view custrom_product_infomation_report as ( select t0.id,t0.hpartner_id as hpartner_id, t0.khwl_code as khwl_code,t1.
DB: 11.2.0.3.0 查看Oracle的redo日志切换频率 两条SQL,原理是一样的,第二个用到了统计函数 时间单位:分钟 方法一. select * from v$log a where a.THREAD# = 1 ; set line 200select b.SEQUENCE#, b.FIRST_TIME,a.SEQUENCE#,a.FIRST_TIME,round(((a.FIRST_TIME-b.FIRST_TIME)*24)*60,2) from v$log_histor
select … into outfile 'path' 备份 此种方式恢复速度非常快,比insert的插入速度要快的多,他跟有备份功能丰富的mysqldump不同的是,他只能备份表中的数据,并不能包含表的结构.如果备份完成之后,表被drop,是无法实现恢复操作的(除非有表结构). mysql> select * from t1 into outfile '/mydata/mysql/mysql3307/data/t1.sql'; ERROR 1290 (HY000): The MySQL se
在对类执行100w次循环后, 常量最快,变量其次,静态变量消耗时间最高 其中: 常量消耗:101.1739毫秒 变量消耗:2039.7689毫秒 静态变量消耗:4084.8911毫秒 测试代码: class Timer_profiler { public static $begin_timer; public static $finish_timer; public static $timer_html; /** * 计算时间差 * @return type */ public static f
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.IO; namespace fileIO { class Program { static void Main(string[] args) { string filename =AppDomain.CurrentDomain.BaseDirectory+ "companyUpdateLog.txt&
https://www.cnblogs.com/xiangsj/p/7977325.html http://www.jb51.net/article/45560.htm isOverdue (time) { time = time.replace(/\-/g, "/") time = (new Date(time)).getTime(); var curTime = new Date(new Date().toLocaleDateString()).getTime(); if (cur