Re: Using DataReader to count rows



> Bear in mind, though, that this is probably not the most efficient use of
> your system resources, and I mention it merely as an example of what is
> possible...


What do you consider might be a better use of resources? I am so confused
about there seems to be 100 ways to do the same thing!!

I thought that datareader would be best for this... we do not need to work
with the data for long, so i figured that a adapter and data set would be
overkill,

what might you suggest to be a better use of resources?

Thanks

Steve


.



Relevant Pages

  • Re: Error: "ran out of resources" running 5,000 row array
    ... So you may have to reduce your data set. ... I'm getting the 'Excel ran out of resources' message ... on any array more than 5,000 or so rows, which seems very low to me. ... I'm using Excel 2007 and have 3 GB of RAM, so it's not clear where the ...
    (microsoft.public.excel)
  • Re: problems with project.,...
    ... just by mere force of the mind we cannot change the way a ... weren't exactly clear in the mind either. ... If one wants two resources to work ... I once again offer you resource leveling - not splitting the guy's ...
    (microsoft.public.project)
  • Re: Help creating database
    ... I, too, am in awe of John & Allen, ... I decided long ago that my mind doesn't go the same places that theirs do, ... to the resources they have available to be able to help themselves. ... The gist of the excellent advice that the other respondents ...
    (microsoft.public.access.gettingstarted)
  • Re: Survivalist Types (with or without the gear needed)
    ... every problem starts to look like a nail". ... As to resources unavailable, a couple examples come to mind. ... sure as heck can't make it a thousand miles cross country in four ... The third which came to mind was the evacuations from New Orleans. ...
    (misc.survivalism)
  • Roles Groups Question
    ... The obvious one which springs to mind is the use of Groups and Roles. ... somethwere which someone has already dont the hard work. ... for any ideas on approach or resources. ...
    (microsoft.public.dotnet.languages.vb)