I think we should close this topic. And Stephen, I think theraot means LINQs "object tracking" feature. Set it to false and the program will query the server for updates/changes.
On Thu, Nov 20, 2008 at 3:44 PM, Theraot <[EMAIL PROTECTED]> wrote: > > wait, did I take this wrong? is the database local to the server or > not? or perhaps they are passing SQL strings from and / or to the > cliend (I hope not)? > > Another thing, you made me remember is how slow the approach of > creating the classes to handle to data with reflection may come to be > (if you do it every time you access the dada, and there is people that > does that). > > Remeber that working directly to the queries without wrapping in > objects is something else that there is who does it. > > By the way, when I said mesure the time, I didn't say in every part at > same time. and still it's necesary to find whats eating time (i.e. the > bottleneck). this will be right to improve any application (web or > not). > > Sure I know what is cache, just maybe I know less about modern > databases engines than I thought... > > On Nov 20, 10:38 am, "Stephen Russell" <[EMAIL PROTECTED]> wrote: > > Do not believe some of these answers! Corrections in line. > > > > Wrong! The assembly of data columns is easy for the engine. Presenting > all > > that wasted data is the expense you want to avoid. If you have a table > with > > 15 textual columns that are not needed, don't waste the bandwidth in > pushing > > that data up from the server in the first place. Secondly you will have > to > > convert this data into an object for your use. The Data reader is light, > > but are you putting it into an object that fits your needs? If so you > have > > to deal with those extra fields again. Why? >
