如何解决超时过期的问题呢??SQL语句如下:
<%
if request("cvalue")<>"" then
dim trades
for each trade in request("cvalue")
trades=trades&"'"&trade&"',"
next
trades=left(trades,len(trades)-1)
sql="insert into product2(model,amount,factory,PNumber,note,sealed,trader) select model,amount,factory,PNumber,note,sealed,trader from product where trader in ("&trades&")"
conn.execute(sql)
end if
%>
当trades取得很多个值的时候就出现过期超时的现象!如:当trades取得下值的时候'GHS-杰讯(少杰)83030358','GHS-大兴83036689','GHS-光辉83684913管类(赛12楼B28)','GHS-佳富利61329592(洲3C016)存储器逻辑光耦单片机','GHS-宝星微83294667(华11C001)主营SST和ISSI','GHS-元亨83678020(华20A343)','GHS-威盛达83278411专营LATTICE和IDT(ISCP)','GHS-利通83041504(都2C028C)','GHS-城南(大头)82812689家电类','GHS-兴胜达83779666专做DS和MAX','GHS-嘉和83957732(都A座8G)IR仙童VISHAY等8脚','GHS-进丰82812118(洲1C040)','GHS-源兴(老猪)83044263','GHS-泽信83294755','GHS-中皇(荣兄)8329192(1都B座13F)','GHS-天虹83041723(都4C083房)','GHS-浩-来货记录本-泰国陈小姐','GHS-浩-来货记录本','GDA-D-B-C2','GHS-越兴83957096(新1C032)','GHS-蓝天电子0754-4460877(老二也老)','GDB-浩-cross'
<%
if request("cvalue")<>"" then
dim trades
for each trade in request("cvalue")
trades=trades&"'"&trade&"',"
next
trades=left(trades,len(trades)-1)
sql="insert into product2(model,amount,factory,PNumber,note,sealed,trader) select model,amount,factory,PNumber,note,sealed,trader from product where trader in ("&trades&")"
conn.execute(sql)
end if
%>
当trades取得很多个值的时候就出现过期超时的现象!如:当trades取得下值的时候'GHS-杰讯(少杰)83030358','GHS-大兴83036689','GHS-光辉83684913管类(赛12楼B28)','GHS-佳富利61329592(洲3C016)存储器逻辑光耦单片机','GHS-宝星微83294667(华11C001)主营SST和ISSI','GHS-元亨83678020(华20A343)','GHS-威盛达83278411专营LATTICE和IDT(ISCP)','GHS-利通83041504(都2C028C)','GHS-城南(大头)82812689家电类','GHS-兴胜达83779666专做DS和MAX','GHS-嘉和83957732(都A座8G)IR仙童VISHAY等8脚','GHS-进丰82812118(洲1C040)','GHS-源兴(老猪)83044263','GHS-泽信83294755','GHS-中皇(荣兄)8329192(1都B座13F)','GHS-天虹83041723(都4C083房)','GHS-浩-来货记录本-泰国陈小姐','GHS-浩-来货记录本','GDA-D-B-C2','GHS-越兴83957096(新1C032)','GHS-蓝天电子0754-4460877(老二也老)','GDB-浩-cross'
2. 设置数据库文件增长方式按兆,比如50M ,或者按百分比3%(默认的10%太大了 )
2. 设置数据库文件增长方式按兆,比如50M ,或者按百分比3%(默认的10%太大了 )还是不行的 ,当数据量很大的时候,按钮都不起作用了!~