linq to entity 与 entity sql 性能

2013-03-29 12:48:23 214 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Vue3多级路由缓存失效的深度解析与实战解决方案本文深度解析了Vue3项目中多级路由下keep-alive缓存失效的根本原因，并提供了三种实战解决方案：通过路由扁平化根治问题、利用状态管理精细模拟缓存效果，以及借助keep-alive-vue3插件快速修复。文章旨在帮助开发者彻底理解Vue Router与keep-alive的协作机制，从而根据项目情况选择最佳策略，有效解决页面状态丢失的难题。阅读详情

一个是用linq to entity写的
一个是entity sql写的
性能杂差别老大呢

linq to entity
100000
00:00:00.8281250
基本在0.8-1之间

entity sql
100000
00:00:00.3593750
基本在0.3-0.5之间

都是加载10W条数据





               IEnumerable<HanModel.Models.ViewModel.Fs_NewsOrClass> query = (

                   db.fs_news.OrderByDescending(fn => fn.Click).Join(

                   db.fs_news_Class, fn => fn.ClassID, fc => fc.ClassID, (fn, fc) =>

                  new HanModel.Models.ViewModel.Fs_NewsOrClass

                       {

                           newsid = fn.Id,

                           newsTitle = fn.NewsTitle,

                           class_ename = fc.ClassEName,

                           class_type = fc.Type_New

                       })).Take(100000).ToList();

               return query;



===============================================================

               string sql = "select top 100000  fn.id,fn.newstitle,fc.classename,fc.type_new from fs_news as fn inner join fs_news_class as fc on fn.classid=fc.classid  order by fn.click desc";

               var cmd = db.Database.Connection.CreateCommand();

               db.Database.Connection.Open();

               cmd.CommandText = sql;

               List<HanModel.Models.ViewModel.Fs_NewsOrClass> fslist = new List<HanModel.Models.ViewModel.Fs_NewsOrClass>();

               using (var reader = cmd.ExecuteReader(System.Data.CommandBehavior.SequentialAccess))

               {

                   while (reader.Read())

                   {

                       HanModel.Models.ViewModel.Fs_NewsOrClass fs = new HanModel.Models.ViewModel.Fs_NewsOrClass();

                       fs.newsid = Convert.ToInt32(reader["id"]);

                       fs.newsTitle = reader["newstitle"].ToString();

                       fs.class_ename = reader["classename"].ToString();

                       fs.class_type = reader["type_new"].ToString();

                       fslist.Add(fs);

                   }

                   reader.Close();



               }



               db.Database.Connection.Close();

               return fslist;