DataSet best practices?

I am new to dotNet so... in my next project it is req.开发者_StackOverflow of me to use DataSet (desktop app). I did understand most of it, but... simple question: Is it better to create one dataset for entire project (150+ tables, 90+ stored procedures...) or is it more advisible to create, should I say, smaller datasets for each app module(performance is very important !!!) Most of App logic is implemented in DB (stored procedures, triggers... DB is ORACLE).

I would recommend against having 1 dataset for everything as each time you instantiate it you would have to create ALL of the tables.

I would recommend logical group.