Re: ADO is slow with AS/400 Database

fiaola wrote:

I'm using ADO to retrieve data from an AS/400 Database, for small
reports, the performance is acceptable, but for larger query, its a
bit slow and at times, it takes up all the memory of my development
machine. Does anyone have a better approach to this issue?

I assume you are using a client-side cursor with your ADODataSet. That
accounts for the memory consumption when the query returns many rows
since a client-side cursor loads the entire result set into local
memory on your workstation. You might consider a server side cursor or
you might write the data to a local text file or database and use that
for input to the report. It is difficult to tell which solution is best
without knowing the requirements of your reporting tool (one pass, two
passe, etc.) and what it can use as a data source.

--
Bill Todd (TeamB)
.

Relevant Pages

  • Re: FTS Performance in SQL 2005
    ... Can you post you query plans and the output of statistics IO ... SQL Server MVP ... Because i've set the MAX sql-server memory to 3.5 GB instead of 4.0 GB ... cost relative to the whole batch, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: System very slow, very difficult to access server, cpu usage l
    ... Memory Timings: ... application or service was still using the registry during log off. ... You need to post copies of the Error Reports from Event Viewer if I ...
    (microsoft.public.windowsxp.general)
  • Re: FTS Performance in SQL 2005
    ... Because i've set the MAX sql-server memory to 3.5 GB instead of 4.0 GB ... its the pipe between the CPU and Memory that could be the bottleneck. ... and that you have a covering index on the columns in the query. ... Plan window will then give you a percentage query cost relative ...
    (microsoft.public.sqlserver.fulltext)
  • Re: FTS Performance in SQL 2005
    ... Now if I do a query directly to the field I would theoretically need: ... SQL Server MVP ... Because i've set the MAX sql-server memory to 3.5 GB instead of 4.0 GB ... cost relative to the whole batch, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Newbie? Do I use Report or Query
    ... <<what I really want is a conceptual model of how forms, queries and reports ... Reports are the counterpart of Forms. ... If based on a query, ... JobCard and JobDetails tables showing the fields in each for further ...
    (microsoft.public.access.gettingstarted)