02 2013 档案
摘要:解1:select top 10 * from A where id not in (select top 30 id from A)解2:select top 10 * from A where id > (select max(id) from (select top 30 id from A )as A)解3:select * from (select *, Row_Number() OVER (ORDER BY id asc) rowid FROM A) as A where rowid between 31 and 40
阅读全文
摘要:对于某些页面内很少发生改变的可以通过页面缓存提升访问速度;对于较少发生变动的业务数据可以通过数据缓存和缓存依赖项保证访问速度和更新;从数据库层面进行优化:优化查询语句、合理建立表索引、数据表的水平和垂直拆分;可以通过服务器群集来对访问量分流相应;
阅读全文