DotNetNewsgroup.com  
web access to complete list of Microsoft.NET newsgroups
   home   |   control panel login   |   archive  |  
 
  carried group
academic
adonet
aspnet
aspnet.announcements
aspnet.buildingcontrols
aspnet.caching
aspnet.datagridcontrol
aspnet.mobile
aspnet.security
aspnet.webcontrols
aspnet.webservices
assignment_manager
datatools
dotnet.distributed_apps
dotnet.general
dotnet.myservices
dotnet.nternationalization
dotnet.scripting
dotnet.security
dotnet.vjsharp
dotnet.vsa
dotnet.xml
dotnetfaqs
framework
framework.clr
framework.compactframework
framework.component_services
framework.controls
framework.databinding
framework.drawing
framework.enhancements
framework.interop
framework.odbcnet
framework.performance
framework.remoting
framework.sdk
framework.setup
framework.webservices
framework.windowsforms
framework.wmi
frwk.windowsforms.designtime
lang.csharp
lang.jscript
lang.vb
lang.vb.controls
lang.vb.data
lang.vb.upgrade
lang.vc
lang.vc.libraries
  
 
start date: Thu, 26 Jul 2007 04:50:02 -0700,    posted on: microsoft.public.dotnet.framework.adonet        back       

Thread Index
  1    Luc
          2    Miha Markic miha at rthand com


Indexing usefull or not??   
Maybe a stupid one,......
is it still usefull to make indexes on the SQL server since in ADO.NET we 
work with complete datasets which contain complete or parts of tables???  

-- 
Best regards
Luc N
Date:Thu, 26 Jul 2007 04:50:02 -0700   Author:  

Re: Indexing usefull or not??   
Indeed. Datasets aren't replacement for the databases and you shouldn't load 
entire database there - just as much data as you currently need.
Furthermore there is still server side processing, too.
etc etc
Bottom line: Yes, nothing changed regarding to indexing.

-- 
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"Luc"  wrote in message 
news:9A7A3A7E-D97C-4A7F-AEC8-75280895CF5E@microsoft.com...

>
> Maybe a stupid one,......
> is it still usefull to make indexes on the SQL server since in ADO.NET we
> work with complete datasets which contain complete or parts of tables???
>
> -- 
> Best regards
> Luc N 
Date:Thu, 26 Jul 2007 16:46:14 +0200   Author:  

Google
 
Web dotnetnewsgroup.com


COPYRIGHT ?2005, EUROFRONT WORLDWIDE LTD., ALL RIGHT RESERVE  |   Contact us