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?
