Do not believe some of these answers! Corrections in line.
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Theraot 1) when using in SQL "SELECT * FROM...." the engine takes extra time to look for the fields of the table (who knows, may be they changed...), but if you provide the list of fields, then it only need to check if they are valid, and that last part can be fasted up with a stored proedure (<- and stored procedure is just like a cache). so avoid the "*". ---------------------------------------------- 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? 2) Ok, the cache on the web page, is something, but ... that's not the only cache!, there is another thing called cache to take in account, are you doing a query every time you need the data? why, you don't store a copy in server memory to only query once every time a page is requested? (note: I mean also to release that copy soon) -------------------------- There are many potential cache layers. Take advantage as necessary. I think that your are restating the same cache here though? 3) yep, LinQ may do an speed up, because it adds another cache layer, if you can place the queries in method outside the webpage, much better. ----------------- What are you talking about another cache layer? 4) sure, XML may help, it's an option to have a long period cache... even I don't think its needed. ----------------------------- Now I have to question if you are knowledgeable about the difference in data usage in the web. ...you don't even know what cache means... --------------------- I must say likewise. ......................... Stephen Russell - Senior Visual Studio Developer, DBA Memphis, TN 901.246-0159
