Some Quick General Questions

Question

I have been working on a vb.net program in visual studio 2008 with a .mdb file. The file will hold two tables: one with roughly 150 rows and 16 columns and the other with about 15,000 rows each with 6 columns. Before I continue, I have some questions about it.

1. I am new to access, but I know it has a size limit. Is a database of this size likely to go over the limit?

2. How much will a large Datatable affect the speed of the program? Is there a Datatable size I should try to stay below?

Martin van Eerde · Answer

I don't think there is a physical file size limit but some applications cannot open a mdf file if it is over a certain size. I think this is 2GB for Access and 4GB for SQL Server Express. How quickly it grows very much depends on the amount of data being written. If you have worries about size and speed perhaps you should change to using SQL Server CE .

Karthikeyan Anbarasan · Answer

Go with the relational database like sql. with which u dont need to care about the size... also you can have best performance since connection pooling facilitates as well