Hi all,
I am facing a optimization issue when binding Datagrid
with Dataset that has around 1,50,000 records as it takes
around 40 second to show, i haven't used datareader
because it remains connected to database till released,
since i am giving my user flexibility to open any number
of form with required data at one time, i took dataset
path, i hope i did right, if yes than my application is
running very slow, could anyone tell me possible problem
in this design or solution to make design better.
I am using VB.Net and Access as backend.
Thanks,
Ashwani.
|