I am Tony ZHOU

Welcome, just another weblog!

  • Home
  • Photo
  • About

15

Jul

将viewstate存储在数据库中并压缩(store viewstate in database)

Posted by Tony ZHOU  Published in ASP.NET

无聊时候写了一个 下图是没有存储viewstate到数据库时 下图是存储到数据库时候,大家可以比较一下性能。 至于页面大小也就不说了,大家都知道如果用一些诸如gridview控件的时候viewstate会相当大的。 web.config里面有两个键值,可以设置来决定是否要存储到数据库或者压缩。   <add key="StoreViewStateInDB" value="true"/>   <add key="CompressViewState" value="true"/> 压缩方面还是用的SharpZipLib,一开始用里面的BZip,但是解压用Compress()这个方法老是报错。只能实例化inputstream outputstream解决,参考了codeproject.http://www.codeproject.com/KB/dotnet/mscompression.aspx 附上代码: http://iamtonyzhou/UploadFiles/ViewStatePractise.zip 提醒:如果存数据库的话需要有个SQL JOB去删除那些不需要的viewstate,可以根据时间判断,每15分钟或者每1小时等。 Job 的 Script,很简单。 USE [msdb] GO /****** Object:  Job [Delete ViewState]    Script Date: 01/07/2009 17:13:59 ******/ BEGIN TRANSACTION DECLARE @ReturnCode INT SELECT @ReturnCode = 0 /****** Object:  JobCategory [Web Assistant]    Script Date: 01/07/2009 17:13:59 ******/ IF [...]

Continue reading...

Tags: compress, database, SharpZipLib, viewstate, 代码, 压缩, 数据库

no comment

Blogroll

  • JinWeiJie

 

July 2008
M T W T F S S
« Jan   Nov »
 123456
78910111213
14151617181920
21222324252627
28293031  

Recent Entries

  • Mirror drivers don’t support Aero effects
  • Disable Annoying System Restart Notification after Windows Automatic Updates
  • ILLEGAL ATTEMPT TO ASSOCIATE A COLLECTION WITH TWO OPEN SESSIONS
  • TooManyRowsAffectedException of nHibernate
  • "waitforcatalog" error on live mesh installation
  • Four ways to Create Linq
  • Refactoring Diary 1
  • jQuery plugin, hint tools
  • An excellent mockup tool — Balsamiq
  • Resolve “Playback engine is already initialized and SkipStepThreadEvent”

Recent Comments

  • alfiesaden in Outlook 2007 Conflicts With Google Desktop
  • Anil in Resolve "Cannot find any coverage data (.cove…
  • Theepi in Resolve "Cannot find any coverage data (.cove…
  • test in "waitforcatalog" error on live mesh inst…
  • 淘宝网女装 in 5 Whys Quickly Getting to the Root of a Problem
  • Max in An excellent mockup tool -- Balsamiq
  • jinweijie in "waitforcatalog" error on live mesh inst…
  • emma in Hello world!
  • JIN Weijie in Get translation authorization from Scott Hanselman…
  • JIN Weijie in Hello world!
  • Random Selection of Posts

    • (翻译)十分钟内安装,配置,使用Windows Server AppFabric
    • Jmail 64bit 64位 不支持 not support
    • Be careful when you compare the GUID with a string
    • "waitforcatalog" error on live mesh installation
    • 5 Whys Quickly Getting to the Root of a Problem
    • Get translation authorization from Scott Hanselman
    • Hello world!
© 2008 I am Tony ZHOU is proudly powered by WordPress
Theme designed by Roam2Rome