Re: Access and processor usage

If you are pulling data from a sql server (MS Sql Server, Oracle, ...)
and you are using an ODBC connection, that would be your bottle neck.
The fix is to use ADO (com based ADO) to pull your data (much more
bandwidth than ODBC). If Access is your backend, then Access is the
bottleneck - need to step up to Sql Server.

If neither of the above are your scenario, and you really are pulling in
hundreds of megs of data, then Access is still the bottleneck. Access
has a 1 gig data limit (more like a 500 meg limit). If you are working
with genuinely big data you need to step up to server based tools like
Net and sql server. ADO.Net has way more bandwidth than com based ADO.

BTW, core2Duo is sweet, heh? I just upgraded my workstation to one last
month - the shop that upgraded me said that you can maximize its full
potential by using 4 gigs of memory.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: % Disk Time
    ... Avg and current Disk queues instead. ... > I have separate drives each SQL Server database: ... > then your SQL Server ... >> Is not a very reliable indicator of an IO bottleneck. ...
    (microsoft.public.sqlserver.server)
  • Re: Parsing XML within SQL Server
    ... also suggest that you make sure you really understand where the bottleneck ... the xml docs in text fields is not responding quickly enough to the client ... parsing might not achieve anything and moving the parsing into SQL Server ...
    (microsoft.public.sqlserver.programming)
  • Re: % Disk Time (Perfmon)
    ... Secondly if you have this counter higher than 55% for continuous periods ... then your SQL Server ... "Brian Moran" wrote in message ... > Is not a very reliable indicator of an IO bottleneck. ...
    (microsoft.public.sqlserver.server)
  • % Disk Time
    ... I have separate drives each SQL Server database: ... How is the % Disk Time measured? ... > Is not a very reliable indicator of an IO bottleneck. ...
    (microsoft.public.sqlserver.server)
  • Re: % Disk Time
    ... I mostly use Average disk queue length... ... Wayne Snyder, MCDBA, SQL Server MVP ... >> Is not a very reliable indicator of an IO bottleneck. ...
    (microsoft.public.sqlserver.server)