net页面,在本地机上很快就完全打开,可是在虚拟主机上明明下载完了却显示"正在打开网页 http...." 而且持续时间很长?
打开页面时 是通过存储过程来取数据
ALTER procedure getresourcebydate
as
select resourceinfo.resourceid as '资源编号' ,resourceinfo.resourcename as '名称',resourceinfo.capacity as '大小',classinfo.classname as '类别',resourceinfo.uploadtime as '上传时间',userinfo.username as '上传者',resourceinfo.downloadtimes as '下载次数'
from resourceinfo join classinfo on ltrim(rtrim(resourceinfo.classid))=ltrim(rtrim(classinfo.classid)) join userinfo on ltrim(rtrim(resourceinfo.uploadpersonid))=ltrim(rtrim(userinfo.userid))
where (datediff(day ,resourceinfo.uploadtime,getdate())<30)
order by resourceinfo.uploadtime desc
GO当把排序字段 换成order by day(resourceinfo.uploadtime) 时,页面就能很快的打开
打开页面时 是通过存储过程来取数据
ALTER procedure getresourcebydate
as
select resourceinfo.resourceid as '资源编号' ,resourceinfo.resourcename as '名称',resourceinfo.capacity as '大小',classinfo.classname as '类别',resourceinfo.uploadtime as '上传时间',userinfo.username as '上传者',resourceinfo.downloadtimes as '下载次数'
from resourceinfo join classinfo on ltrim(rtrim(resourceinfo.classid))=ltrim(rtrim(classinfo.classid)) join userinfo on ltrim(rtrim(resourceinfo.uploadpersonid))=ltrim(rtrim(userinfo.userid))
where (datediff(day ,resourceinfo.uploadtime,getdate())<30)
order by resourceinfo.uploadtime desc
GO当把排序字段 换成order by day(resourceinfo.uploadtime) 时,页面就能很快的打开
解决方案 »
- 一个回调问题,求高手!!
- aspx页面火狐下出现XML解析错误:未组织好
- 请教一个在WEB开发中SqlConnection的对象管理问题,因为要将Session保存到SQL服务器中.
- 请教大家关于DataGrid与listview显示数据 的优缺点对比
- 一个Regex.Replace转换问题,mm急求!
- 大问题。大问题。。。。
- PetShop4.0无法创建新用户,老是提示“Please enter a more secure password”,谢谢
- 請問在 ASP.NET中怎樣分別取得當前的日期和時間???
- XML请教
- 求解,ASP.NET编程,对云服务器的文件进行备份
- 请教虚拟主机部署asp.net程序的问题
- ####大家讨论一下在虚拟主机中,做asp.net2.0如何用Access做membership数据库???####
打开页面时 是通过存储过程来取数据
ALTER procedure getresourcebydate
as
select resourceinfo.resourceid as '资源编号' ,resourceinfo.resourcename as '名称',resourceinfo.capacity as '大小',classinfo.classname as '类别',resourceinfo.uploadtime as '上传时间',userinfo.username as '上传者',resourceinfo.downloadtimes as '下载次数'
from resourceinfo join classinfo on ltrim(rtrim(resourceinfo.classid))=ltrim(rtrim(classinfo.classid)) join userinfo on ltrim(rtrim(resourceinfo.uploadpersonid))=ltrim(rtrim(userinfo.userid))
where (datediff(day ,resourceinfo.uploadtime,getdate())<30)
order by resourceinfo.uploadtime desc
GO
当把排序字段 换成order by day(resourceinfo.uploadtime) 时,页面就能很快的打开 ,这是什么原因呀