Re: ADO is slow with AS/400 Database
- From: "fiaola" <fiaola@xxxxxxxxx>
- Date: Sun, 10 Jun 2007 20:29:38 -0700
Thanks for the tip. Unfortunately, it says "current record type does not
support bookmarks. It may be a limitation of the provider or cursor type".
"Bill Todd" <no@xxxxxx> wrote in message
news:466ca96b$1@xxxxxxxxxxxxxxxxxxxxxxxxx
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)
.
- References:
- ADO is slow with AS/400 Database
- From: fiaola
- Re: ADO is slow with AS/400 Database
- From: Bill Todd
- ADO is slow with AS/400 Database
- Prev by Date: Re: ADO is slow with AS/400 Database
- Next by Date: Find out how I saved $300 dollars by switching to Geico
- Previous by thread: Re: ADO is slow with AS/400 Database
- Next by thread: Re: ADO is slow with AS/400 Database
- Index(es):
Relevant Pages
|
