V
vanvee
Hi
I have an application for my company's HR department where we store
resumes for candidates we receive. I have an application that uses
VB.Net and ADO.Net and data bindings (through code) to controls on a
Windows form. The question I have is that once the database grows and
contains a large number of records, I am worried the dataset is going
to create too much overhead when the user clicks "show all records"
(the full resume which contains a lot of text is retrieved for each
record so the dataset will contain lots of text for lots of records).
On the other hand, if I connect to the database everytime the user
clicks next / previous / first / or last, I am worried that the
application will run too slowly. Does anyone have any recomendations
as to which technique (or any others to use) will be better when the
database grows to a large (tens of thousands) number of records??
Sorry if this is a dumb question to anybody but I can't seem to find
any articles / books that address a topic like this. Thanks in advance
for your help!
I have an application for my company's HR department where we store
resumes for candidates we receive. I have an application that uses
VB.Net and ADO.Net and data bindings (through code) to controls on a
Windows form. The question I have is that once the database grows and
contains a large number of records, I am worried the dataset is going
to create too much overhead when the user clicks "show all records"
(the full resume which contains a lot of text is retrieved for each
record so the dataset will contain lots of text for lots of records).
On the other hand, if I connect to the database everytime the user
clicks next / previous / first / or last, I am worried that the
application will run too slowly. Does anyone have any recomendations
as to which technique (or any others to use) will be better when the
database grows to a large (tens of thousands) number of records??
Sorry if this is a dumb question to anybody but I can't seem to find
any articles / books that address a topic like this. Thanks in advance
for your help!