Hello... 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 "*".
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) 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. 4) sure, XML may help, it's an option to have a long period cache... even I don't think its needed. ...you don't even know what cache means... And why is Troy asking?, isn't this thread started by Venkatu? what's going on here? and wtf, with "hello"? did Venkatu use Troy as a cache? 5) may be you just have a huge flash in the front page >_< (joke), Want steps to speed up? - Measure the time of the procedures in the server, to look out what eating time, speed that up, check again, is already enought fast? not... then repeat. May the cache be with you ~theraot
