Hi all

At work we have a database that is read only that keeps track of the work we do ( who completed what ticket and so on) I need to take a chunk of the database for the work done by my group then count up certain types of information like who has done how many tickets or how many of one type of problem there was during a certain time.

question 1) can i use the fact that this is read only to my advantage in terms of speed or memory i saw something called sqlreader but i haven't had time to play with it yet


question 2) given the senerio above what would be the most efficient work flow? should i read the database into a dataset then do my filtering from there or something else


unfortunately this is not my strongest subject so all suggestions are appreshated