Hi there
I am writing/revising an asp.net (vb) website
the main function of the site is to fetch data from a SQL server and present it to users based on 'filters' that they apply
(It for football statistics)
currently a session variable is used to store the unique match_id's, and then there are around 10 - 20 query's (datareader) to the database to populate the stat gridviews, for each one the session variable that holds the unique match_id's is looped through to provide the list of matching match_id's to use in the database querys.
Now the main problem is that this performs terribly, and i am trying to learn the best way to do this (googles a little confusing for a green beginner).
Should I grab a large query from the database and then store it in memory (how: dataset, datatable, session variable) (couple of hundred records over a few different tables)
Should I stick to multiple queries to the database or just do one and what is the best way to store 'tables' in memory??
sorry its not very concise.
Many thanks, Gary