I have a couple of questions on the performance of the disconnected DataSet

model.



Is there a limit on the size of the DataSet?



Can you build an index on a table in a DataSet?



If yes, where can I find an example?



Does the DataSet model perform at the level of a DataBase that is all in

cache?



 The reason I'm asking is that I would like to use the DataSet model to

load some small ( 500 row ) tables that are read only and the datasource is

just a directory of XML files.



Thanks.

Is there a limit on the size of the DataSet?



	As I know, the only limit is amount of memory you have



Can you build an index on a table in a DataSet?



	I have no idea about that..



If yes, where can I find an example?



Does the DataSet model perform at the level of a DataBase that is all in

cache?



	Yes, it is inthe cache, 100% disconnected from data source



 The reason I'm asking is that I would like to use the DataSet model to

load some small ( 500 row ) tables that are read only and the datasource is

just a directory of XML files.





	Even if you can create index on so small portion of data, index can't

improve performace.